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!

asked 03 Apr '12, 20:07

StephenWells's gravatar image

StephenWells
31114
accept rate: 0%

edited 03 Apr '12, 20:08


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.

permanent link

answered 03 Apr '12, 20:56

Justin%20Willey's gravatar image

Justin Willey
6.8k110142212
accept rate: 20%

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.

(04 Apr '12, 03:31) Volker Barth

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!!

(04 Apr '12, 19:10) StephenWells
Replies hidden
1

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.

(05 Apr '12, 02:44) Dmitri

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.

(05 Apr '12, 03:19) Volker Barth

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.

permanent link

answered 05 Apr '12, 17:12

JBSchueler's gravatar image

JBSchueler
2.0k2837
accept rate: 15%

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:

×31

question asked: 03 Apr '12, 20:07

question was seen: 1,258 times

last updated: 05 Apr '12, 17:12