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:
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
asked 19 Jan '12, 05:42
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.
answered 19 Jan '12, 06:43