I have an old Sybase 5 db file that I have to migrate (just for development purposes) Is there a quick/easy way to do this or Is there a JDBC driver I can use in Servoy?
Thanx,
Raymond Gerz
AWEsome Numbers
Just to clarify my previous post, I am trying to use a Sybase 5 file within Servoy developer. Is this possible?
Ray
Hi Raymond,
You say you have a Sybase 5 database, doesn’t this also need a Sybase 5 database server to connect to with a jdbc driver ?
Or does some Sybase 5 jdbc driver allow you to connect to the database file directly ?
Anyway, I think you need to look for a jdbc driver on the Sybase site somewhere and/or contact Sybase support.
Hi Ray,
I assume that by Sybase 5, you mean SQL Anywhere 5. That is a very old version, but you can still migrate the database. You can download the free Developer Edition of SQL Anywhere 9 so that you get the database server. That version will allow you to open a SQL Anywhere 5 database. Obtain the software from here:
http://marketing.ianywhere.com/forms/SQ … DevEdition
After you install, just launch the database server with your SA5 database: dbeng9 my_sa5db.db
Once this is done, you have 2 options for the migration:
- Open Sybase Central, connect to the database, and choose to migrate the database to version 9.
- Open Sybase Central, connect to the database, and choose to unload the database into an SQL script. Once you have the script, you can re-load it into a brand new database.
We recommend that you go with option #2, particularly if you want to get a database version for SQL Anywhere 11 (the latest and greatest version of SA). Starting with SA10, you cannot open database files from earlier versions - that is why I suggested that you download SA9. If you do want to try SA11, you can get the Developer Edition from here:
http://marketing.ianywhere.com/forms/SQ … loadsybase
I hope this helps you!
Regards,
José Ramos
Product Manager
Sybase, Inc.
Thanx Robert & José for your input. I will attempt your suggestion José.
Cheers!
Ray