Q: How do I port a database from Windows to UNIX platform?

A: If both platforms use the same CPU, such as the Intel x86, then porting is easy. All you need to do is copy the database files (the data, journal and blob files) from one platform to another. Then copy all the information for your database from dmconfig.ini and apply it to the dmconfig.ini file on the destination platform. Make sure that parameters like DB_DbDir , DB_JnFil , DB_BbFile , etc. all point to the correct directory or paths. If both platforms use different CPUs, then you have to unload the entire database from the Windows platform. You will find two script files with the file extensions .s0 and .b0 . Copy these two files to the UNIX platform and use them to load your database. The following steps show how to port the database db1 from the Windows platform to the UNIX platform.

On the Windows Platform

Start dmSQL and enter the following commands ( db1port is the script file):

		  dmSQL> connect to db1 SYSADM; dmSQL> unload db to db1port;
		  

On the UNIX Platform

Copy the files db1port.s0 and db1port.b0 to the UNIX platform. Start dmSQL and enter the following commands:

		  dmSQL> create db db1;
		  dmSQL> load db from db1port;