Import Sybase 9.0.1 .db file into ASE 15.0
Posted on 2006-07-06
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, 188.8.131.521 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.