All geek questions in one place

Sql anywhere 5.5 database connects to sql anywhere 12

I have a database file created in sql anywhere 5.5, and I need it to connect to sql anywhere 12. I tried, but it will not accept it, saying that:

"This database was created in the old version of sql anywhere

+3
source share
1 answer

As with SQL Anywhere 10.0, the database server no longer reads database files created using older software; they must be rebuilt. The easiest way is to upload your database to a new one using the dbunload tool. You can do this in one step:

dbunload -c uid=<user>;pwd=<password>;dbf=<DBFileName> -an <newDBFileName>

, 12. ( ), :

  • dbunload, old, , - dbunload -c uid=<user>;pwd=<password>;dbf=<DBFileName> unload. "unload" .dat. "reload.sql" script.
  • .
  • dbinit, new, (, , ..).
  • dbisql -c uid=<user>;pwd=<password> reload.sql

: Sybase SQL Anywhere.

+2

Source: https://habr.com/ru/post/1779228/

More articles:


All Articles