Solved

Import Sybase 9.0.1 .db file into ASE 15.0

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Unable to get exact error from Sybase Sp to Sql Server 2005 2 396
SyBase SQL Syntax 7 320
How to install new sybase instance in Linux 4 712
SyBase SQL Query 7 166
If you are looking at this article, you have most likely been hit by some version of ransomware and are trying to find out if there is anything you can do, or what way you should react - READ ON!
ConnectWise and their customers need to ensure critical alerts automatically reach the right person at the right time. MSP superheros efficiently respond to these alerts key is providing automatic, intelligent alerting that generates a complete audi…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

790 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