Unanswered: Extract SQL statements from the old sybase DBMS (10.0 or 11.5)
I'm a newbie to Sybase. I was assigned a task to migrate the databases in the old sybase version (10.0,11.5) to the current Sybase version or extract the sql statements from the data device files (.dat). And the old DBMS cannot be on the running-time states becasue we don't have the DBMS rec, which means I only have some .dat files and bcp backup files. Can anyone point me a direction of how can I get the SQL file out of these cold data files without start the old sybase DBMS. I have installed a latest sybase ASE express edition.
Thank you very much
If they are bcp files, then all you need is a TEXT editor. If these are actual sybase data and trransaction devices, then you have to start them under the same release of Sybase and then perhaps bcp out.
Thanks willy. I have some bcp output files. Why do I need a text editor? for what? Can you give me some more detail information? I read the bcp information in the sybase manual. It seems they don't need text editor to change someting. Are they compatible with the new version?
Another question, we have many .dat file which is the device files for sybase to put data. Is it possible any tools can extract the data directly from .dat files? Please give me a direction. I read some articles said that MS access and powerbuilder have the ability to extract data from .dat files, is it correct?
Thank you very much.
Thank you. I got an old version Sybase ASE(11.0.33) installed. But I didn't find any document to talk about how to recover my old .dat files (master.dat,model.dat...etc.) to this new installation. Could you please point me a direction? I read almost all documents for 11.0.3 on the syabse website.
To start using the old .dat files again, I'll create a new 220.127.116.11 server that has a master device the same size as the old e.g.
# ls -l master.dat
-rw-r--r-- 1 syb1103 sybase 104857600 Jul 24 09:37 master.dat
# echo $((104857600/1024/1024))
So in this case create a 100MB master device
Then shutdown, copy your old master.dat over the newly created one
Start the new server in single user mode
select * from sysdevices to find what the path to all the devices are
shutdown with nowait and copy all devices to the required paths
OR just update sysdevices with the new path to the devices
after restart all should be OK