Solved

Import Sybase 9.0.1 .db file into ASE 15.0

Posted on 2006-07-06
4
1,188 Views
Last Modified: 2012-08-14
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.

0
Comment
Question by:RussoMA
  • 2
  • 2
4 Comments
 
LVL 19

Accepted Solution

by:
grant300 earned 500 total points
ID: 17063330
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
 

Author Comment

by:RussoMA
ID: 17073329
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
 

Author Comment

by:RussoMA
ID: 17075996
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
 
LVL 19

Expert Comment

by:grant300
ID: 17077110
That's great.

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

Bill
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
In 2017, ransomware will become so virulent and widespread that if you aren’t a victim yourself, you will know someone who is.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now