?
Solved

Import Sybase 9.0.1 .db file into ASE 15.0

Posted on 2006-07-06
4
Medium Priority
?
1,238 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 2000 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
In-App Messaging has revolutionized the way we look at marketing. It has also changed the way we use Apps. If In-App Messaging is used well then you will find that it can drive a lot of traffic to specific areas of your site. It also helps to improv…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses
Course of the Month6 days, 16 hours left to enroll

593 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