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] answered 13 Mar '17, 13:34 Nick Elson S... 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 '17, 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 '17, 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" answered 13 Mar '17, 13:47 Breck Carter |