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

asked 19 Jan '12, 05:42

sam's gravatar image

sam
315141624
accept rate: 0%


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.

permanent link

answered 19 Jan '12, 06:43

Justin%20Willey's gravatar image

Justin Willey
6.8k110144212
accept rate: 20%

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:

×65
×45

question asked: 19 Jan '12, 05:42

question was seen: 1,078 times

last updated: 19 Jan '12, 06:43