The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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.4k102132197
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:

×62
×45

question asked: 19 Jan '12, 05:42

question was seen: 972 times

last updated: 19 Jan '12, 06:43