Import Sybase 9.0.1 .db file into ASE 15.0

I have installed ASE 15.0 onto Ubuntu Server, it is up and running.

I have a file, "central.db" which i want to import.
Opening the file in a text editor, I see near the top "Copyright(c) 2000, 9.0.1.1751 Sybase, Inc."

This is a file from a backup on the production machine that the vendor will not give access to other than to copy the .db file from a backup.
vendor is not cooperative on much here, so i'm pretty much on my own to get this running (originally they told me it was a db2 format file to give you an idea).

i'm wondering if there is a quick way that i can get this to import into ASE?  I'm text only in ubuntu server, so no gui tools, only command lines.

i need this to be a process that i can automate daily as i will be writing another script to copy the file from the remote server after the backup has completed and then initiate this process (whatever it may be) to bring that database online and live with the new data from the previous day.  

I'm new to sybase, i'm a moderate linux user, and the .db file seems to have all the structures of the database in parsing it within the text editor.

RussoMAAsked:
Who is Participating?
 
grant300Commented:
The first assumption that you have to validate is that the source database is indeed a Sybase ASE-15 database.
If it is, great, now you only have a difficult task....  Unfortunately, you have given me just enough information to
figure out it is probably not.

My suspician is that it is actually a Sybase ASA (Adaptive Server Anywhere) database and not an ASE
(Adaptive Server Enterprise) database.  There was no ASE version 9.0.X but there was ASA v9.x around.

That is actually good news for a couple of reasons:
1)  It is much easier to deal with an unknown ASA database than it is a backup of an ASE database.
     For instance, you need to restore to the same version that it was backed up from.  Worse yet,
     you have to build your databases and segments the exact same way they were done on the
     source server.
2)  If you need to purchase a license, ASA is less expensive than ASE.

You can download version 9 of SQL Anywhere Developers Studio at:
http://crm.sybase.com/sybase/www/iAS/developer_download_registration.jsp?tpl=ias

It may very well be that you can just start the database server against the .db file an be on your way.
You may also have to poke around for a slightly older version to match what you have but most of the
time Sybase does a pretty good job of making this backward compatible.

Assuming that works, you will need to log into the sucker.  If you have a user account you can use
that to get started, if not, things will be a bit trickier.

Let me know if this works for you or if you run into something you need more help with.

Regards,
Bill
0
 
RussoMAAuthor Commented:
i have downloaded the version as you suggested, it installs on win32, but the linux install completes, and when i try to run

sudo /opt/sybase/SYBSsa9/bin/dbsrv9 -n myserver /opt/sybase/data/Central.db -n mydatabase

i get the following returned:
error while loading shared libraries: libdbserv9_r.so: cannot open shared object file: No such file or directory.

i did some research on this and i have all the libraries installed that are supposedly needed for it to run correctly.  there arent many references to this file online at all.

for the sake of this question, if someone can walk me through the windows version of attaching the database, i'll see if we can get the file attached to at least see the feasibility of getting this running.

it would be bonus if anyone out there could also help me fix my linux error as when/if this does work, i will be housing it on the linux server (ubuntu).
alternatively, if anyone knows how to automate a process of stopping the service on win32 copying the db file and then restarting the service, i would accept that as a solution.

but for the sake of this question, getting the database attached is the primary objective.
0
 
RussoMAAuthor Commented:
was a PATH issue for the library

had to also copy .log files (backup.log, central.log, rebuild.log)
and voila... up and running.
0
 
grant300Commented:
That's great.

Let us know if you need any help digging through what you inherited.

Bill
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.