Migration Error: describe_java_format

[Former Member]

I'm migrating SQL Anywhere 6.0 database to the 12.0 version. I have unloaded the database structure using the Sybase Central 3.0. The unloading was successful. After that I created a new SQL Anywhere 12.0 database using the Sybase Central 6.1, and used loaded the database structure with iSQL using following command:

read c:\\..\\reload.sql;

I'm getting the following error:

Could not execute statement.
Invalid option 'describe_java_format' -- no PUBLIC setting exists
SQLCODE=-200, ODBC 3 State="42000"
File: "reload.sql" on line 11, column 34
You can continue executing or stop.

SET OPTION describe_java_format= 'binary'

How this should be fixed? Thanks

[justin_willey · Accepted solution]

There are huge differences between v6 and v12, particularly with regard to Java. You need to do your unload using the facilities in v12, which will produce a reload file compatable with v12 - a v6 one (as produced by Sybase Central 3) won't be.

Have a look here for detailed instructions.

If you are using java features, you will need to have a look at the extensive Java changes by going through all the Behaviour Changes sections in the documentation for v6 > v7 > v8 > v9 > v10 > v11 > v12, see here for 10 > 11 > 12 changes & here for v6 > v7 > v8 > v9 > v10 changes.

Besides Java there are likely to be other changes that affect your application and database.

Good luck with the process. If you run into other problems I suggest posting them here as new questions.