Moving from SQL Anywhere 9 to 12

[Former Member]

I'm doing a pilot project to see what effort would be required to move our SQL Anywhere 9 database to version 12. I'm wondering what the proper approach would be to accomplish this. In Sybase Central for SQL Anywhere 12, I unloaded the v9 database and then loaded it into a new v12 database. It finished without producing any errors so does this mean it was a clean migration???

Thanks,

[Former Member · Accepted solution]

That should be the correct procedure according to the documentation. If there were no errors, then nothing was noticeably wrong with your upgrade from the perspective of the database server and all of the tables, procedures, data, etc... should have been migrated. The static structure of your database should have been restored.

Note that it is always prudent to heavily test your application after such a significant change before placing it into a production environment. It's always a possibility that something was missed or that some behaviour change (intended or otherwise) has broken the run-time behaviour of your database.

[VolkerBarth · Accepted solution]

Therefore I would highly recommend the docs, particularly the bunch of "behavior changes" pages.

Besides that, you usually would like to know not only about things that do not work anymore (or different than before) but also check how you will take advantage of new features...

[Breck_Carter · Accepted solution]

I agree that you should read the "Behavior Changes" sections. The database migration worked, but will your application work?

[Former Member · Accepted solution]

Yes, full system testing will have to be performed to make sure that everything still works. I wanted to make sure that "step 1" was done right. Thanks everyone.

[Former Member]

In our migration we found that synch scripts didn't work the same.