I am new to Sybase. I have a production server running what I think is version 8 of ASA or perhaps SQL Anywhere. They have given me a copy of the .db file to do development against. I am not allowed to connect to the production database as I am a lowly developer.
What do I do with the file? I don't believe we have any installation media around as it is a legacy system. They are happt if I upgrade it but I tried downloading v11 and v12 but I could not seem to load it up.
Is there a way to get at the .db file without installing v8? Or is there a copy of v8 somewhere I can download?
You don't need v8, but before you can run the database under v11 or v12 you have to re-build it first since 11 & 12 won't read database files older than v10.
In essence you unload your v8 database using the Unload Database Wizard (in Sybase Central | Tools), create a new v12 or v11 db, connect to it and then reload the structure and data. It's not too complicated when you get your head round it :). Best thing is to read these detailed instructions first, try it and then re-post here if you get stuck.
answered 03 Apr '12, 20:56
If you have a newer version of SQL Anywhere, you can unload pre-10.0 databases. Read this web page.
And, yes, you will need the credentials (UID and PWD) to connect.
answered 05 Apr '12, 17:12