cancel
Showing results for 
Search instead for 
Did you mean: 

How can I access database file from ASA v 8?

Former Member
3,219

Hi,

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?

Thanks!

Accepted Solutions (0)

Answers (2)

Answers (2)

justin_willey
Participant

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.

VolkerBarth
Contributor
0 Kudos

FWIW: In case you have or can get a v9 setup (thought that is now a legacy version as well): v9 can run v8 databases without the need to rebuild the database file.

That might make the start easier. However, for new development (or simply if you prefer GUI-based tools and Wizards), I would strongly suggest to use v11 or v12.

Former Member
0 Kudos

Yes but the problem there is that I would need access to the production database server, which I don't have.

Assuming they did let me connect to the production database, I would also need to take it offline in some respect to unload it right? As the system is live we don't want to do that at this stage.

Is there anywhere to get the v9 installation media?

EDIT: Actually I see now that I just need to connect to the .db file on my local computer. I get the following output:

dbunload -v -c "UID=dba;PWD=;DBF=D:Tempdb_v8.db" -r "D:Tempreload.sql" -ii "D:Tempunload" Connecting and initializing ** SQL error: Unable to start specified database: autostarting database failed An error occurred while attempting to unload the database 'D:Tempdb_v8.db'.

Is this because of incorrect username and password (which I don't know) or something else?

Thanks!!

TBH you story is very strange. If they want you to do something useful with the database, why didn't they give you server installer, UID/password to log in and all that stuff?

As for the V9 install - it may be in the developer versions section (sorry, I'm too lazy to check it myself :)). However, I strongly recommend against development on the server version different from the production one.

VolkerBarth
Contributor
0 Kudos

Just to add: If you have a copy of the production database, the login credentials will be the same - or someone from the company would have changed the credentials in the copied database and then should give these changed credentials to you, in case they won't let you know the "production credentials" (which might make sense IMHO).

This forum won't be able to help you to find out these credentials, for obvious reasons.

jack_schueler
Product and Topic Expert
Product and Topic Expert
0 Kudos

If you have a newer version of SQL Anywhere, you can unload pre-10.0 databases. Read this web page.

http://dcx.sybase.com/index#1201/en/sachanges/unloading-reloading-upgrading-newjasper.html*d5e26987

And, yes, you will need the credentials (UID and PWD) to connect.