You need restore this backup and to do this must be the same major version of IDS, same major version of SO and same processor architecture .
So, if the backup are create over a IDS9.40, Linux , processor Intel x86.. the restore must be the same or a compatible enviroment...
Now, if your backup are a IDS 10 or newer and you already have a IDS 10 installed you can use the archecker utility to restore only the table what you want to a TXT file.
If have your Informix availabe, online and is not a problem execute a big SQLs...yes the backup is out of the question.
The best way to do this copy... well.. this is relative...
Will be very simple using ODBC connecting with Ms-DTS for example, but isn't fast, i believed.
You can export all data to TXT file and load on the Sql Server. but this proceeding is a little hard to do...
Well in this case you will must restore your database...
The basic steps to restore:
1) Install the same version of IDS
2) Restore a backup of your ONCONFIG file
if you don't have, is possible create a new, but some parameter need same exactly equal when the database backup made...
3) define the parameter TAPEDEV to file of your backup
4) create the files to chunks (must be exactly the same patch used before)
If you don't know the path , when execute the "ontape -r" the first think it do is show a list with all chunks and your path+files.
5) execute the command "ontape -r" to start the restore.
If you have only the file of backup level 0 , answer "No" to restore with logical log and backup Level 1 .
- Restore the database with version 7.31 ... make sure all data are recovered
- If you really want work with version 11.10... install the version 11.10 TC2 on the same machine. Shutdown the version 7.31, copy ONCONFIG to 11.10 instalation and start the instance, the upgrade is fast and automatic.
If you want to execute a "external backup" coping the chunk files.. yes that works... you can stop the IDS, copy the files and restart. On really you don't need stop the database, you can only put it in "block checkpoint", do the copy, and back "unblocked" :
1) "onmode -c block" or stop IDS
2) copy chunk files
3) "onmode -c unblock" or start IDS
About the access with odbc... you only can access the database if IDS are ONLINE.
The access with ODBC is a TCP/IP conection...
Thanks for your help once again.
I created another test database and that works ok now.
I will try to run a dbexport at my client's site in order to extract the data.
Then dbimport the files into my test database, and then use odbc to connect to it via Progress.
I currently only know that the backup file is 15gb, so would you be able to extimate how large the actual database is, and how long a dbexport would take to run?
Also is there anything I should watch out for, or any extra parameters I could use in the dbexport syntax in order to increase the chance of it working correctly?