Solved

Import Sybase 9.0.1 .db file into ASE 15.0

Posted on 2006-07-06
4
1,184 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

706 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

22 Experts available now in Live!

Get 1:1 Help Now