Hello I have a database created in SQL Anywhere v9.02 and i need to upgrade to sybase 17...What can I do??? there is any way to make it directly??? please help me

asked 13 Mar, 13:16

dara88's gravatar image

dara88
79114
accept rate: 0%


The version 17 software (once installed) includes a utility (dbunload) that can do that for you.

Following the instructions on how to do that should make that fairly painless. There is even an easier way to do that using SQL Central if your are already familiar with Sybase Central.

If you use MobiLink or SQL Remote then you will also need to consider the requirements for replication and synchronization.

[TIP: take a full safety copy/backup of the files before you begin is always a best safe practice]

permanent link

answered 13 Mar, 13:34

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
6.9k29101
accept rate: 31%

edited 13 Mar, 13:41

I have tried this instructions but when the new database was being created there was an error "Authentication violation"...how can I fix it???

(14 Mar, 08:08) dara88
1

Authentication violation is an error that comes up with the OEM Authentication Edition of the software.

If you are the software author (OEM) and are migrating your development to a new release then you should probably complete your development and testing with the Developer Edition or full product.

If you are migrating a customer you should following the steps documented here: http://dcx.sap.com/index.html#sqla170/en/html/814c3bca6ce210148100cbc950c42f82.html

If you are not the OEM then you need to work with your software vendor. In some cases you may need to purchase the full product if your use is beyond the scope of that application.

(14 Mar, 12:16) Nick Elson S...

I just tested the following Windows batch file on asademo.db originally created with 9.0.0 (1108), and it worked OK to create asademo17.db using 17.0.6.2806...

CAUTION: You should read all the "behavior changes" sections in the Help files for versions 10, 11, 12, 16 and 17 to see if anything affects you.

REM If you're a command-line kinda guy, here is my template Windows 
REM batch file run_dbunload_upgrade_v9_to_v17.bat. It does the 
REM unload-reload-all-in-one-dbunload-step, then starts dbeng17 
REM and dbisql so you can make sure the new database is up and running.

REM Be sure to stop *all* database engines on the computer you're using, 
REM before starting the upgrade.

REM dbunload...
REM -an ...  where to put new database
REM -ap ...  new database page size
REM -c ...   old database startup connection string
REM -o ...   where to put unload console display text file
REM -v       verbose mode for console display

PAUSE MAKE SURE YOU DO NOT HAVE ANY ENGINES RUNNING.

"%SQLANY17%\bin64\dbunload.exe"^
  -an asademo17.db^
  -ap 4096^
  -c "DBF=asademo.db;UID=dba;PWD=sql"^
  -o dbunload_log_asademo.txt^
  -v

PAUSE dbunload/reload done...

"%SQLANY17%\bin64\dbspawn.exe"^
  -f "%SQLANY17%\bin64\dbeng17.exe"^
  -o dbeng17_log_ddd17.txt^
  asademo17.db 

PAUSE dbeng17 started...

"%SQLANY17%\bin64\dbisql.exe"^
  -c "ENG=asademo17;DBN=asademo17;UID=dba;PWD=sql" 

PAUSE dbisql running...

The dbunload output:

SQL Anywhere Unload Utility Version 17.0.6.2806
Connecting and initializing
Unloading user and group definitions
Unloading table definitions
Unloading index definitions
Unloading functions
Unloading view definitions
Unloading procedures
Unloading triggers
Unloading SQL Remote definitions
Unloading MobiLink definitions
Creating new database
Unloading "DBA"."sales_order" (648 rows)
Unloading "DBA"."sales_order_items" (1097 rows)
Unloading "DBA"."contact" (60 rows)
Unloading "DBA"."customer" (126 rows)
Unloading "DBA"."fin_code" (7 rows)
Unloading "DBA"."fin_data" (84 rows)
Unloading "DBA"."product" (10 rows)
Unloading "DBA"."department" (5 rows)
Unloading "DBA"."employee" (75 rows)
Creating indexes
Creating indexes for (1/9) "DBA"."sales_order"
Creating indexes for (2/9) "DBA"."sales_order_items"
Creating indexes for (3/9) "DBA"."contact"
Creating indexes for (4/9) "DBA"."customer"
Creating indexes for (5/9) "DBA"."fin_code"
Creating indexes for (6/9) "DBA"."fin_data"
Creating indexes for (7/9) "DBA"."product"
Creating indexes for (8/9) "DBA"."department"
Creating indexes for (9/9) "DBA"."employee"
permanent link

answered 13 Mar, 13:47

Breck%20Carter's gravatar image

Breck Carter
27.0k424582830
accept rate: 21%

edited 13 Mar, 13:49

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×97
×73

question asked: 13 Mar, 13:16

question was seen: 88 times

last updated: 14 Mar, 12:16