Transfer Database

Export
An existing database can be exported into a file that can be later used for re-creating ("importing") the same database on a different platform. The export file contains the full structure of the database, including all of its tables, views, indexes etc., in a database-independent format.

This allows moving of the databases between different RDBM systems, located on different computers with different OS (e.g. STEP FORWARD's setup built on Sybase running off Windows XP can be copied into another database (e.g. McKoi, Mimer) running on Linux). This feature makes databases portable as may be required by Configurator Consultants who sell their "vertical applications."

The user should select the database to be exported, type in the name of the export file, or press Set... button to specify it in the Open File panel.



Import
A database that has been previously exported into a file, can be re-created (under a different name, if necessary) using this utility. The user should type in the name of the export file, or press Set... button to select it from the Open File panel.



Initially, the name of the newly imported database is set to the name of the file from which it is imported. It can be changed in the "Automatic" or "Manual" tab views, observing the naming conventions of the underlying RDBMS (most common restrictions on the database name are: the first character in the name must be alpha, blank spaces are not allowed, etc. In STEP FORWARD, the database name is limited to 30 characters).

For some databases (McKoi, Mimer, MS SQL Server 2000) using the "Automatic" tab view is sufficient for entering the database name. Other databases (Sybase) may require some additional parameters set in CREATE DATABASE command, such as the name of the data segment and amount of space to be allocated off it. In these cases the full CREATE DATABASE command should be entered in the "Manual" tab view.

 

Go to:
Index
Table of Contents