|
|
Ispirer SQLWays Database Migration Software
Stage 1. Exporting and Converting
At this stage, SQLWays exports and converts the whole source database or certain database objects. In the latter case, you are to choose any of the objects belonging to the following types:
Having chosen the objects, you can change the name of each table, column, view, stored procedure, function or trigger. If required, you can also redefine the data type mapping between the source and target databases used by default. It can be done by changing the global data type mapping (for all tables) or local data type mapping (solely for selected tables). Besides, you can select the properties of the objects due to be converted.
During the export, SQLWays converts the source database and creates SQL files, which contain SQL statements used for creating database structure in the target database. Also, there are created ASCII files that contain data exported from tables and import scripts used for importing the database.
Export files
The created files depend on the target database.
How to perform export and conversion with SQLWays Wizard
Launch SQLWays Wizard. You will see the Welcome page. Click Next and indicate a source database. On the next page, indicate a target database. On the page "Specify Database Objects or Query" indicate the database objects (tables, views etc.) to be exported.
On the next three Wizard pages, you can specify conversion, export and import options. Then click Next to start export. The Wizard will export and convert the source database with the specified options and create import scripts for the specified target database.
For more information about using SQLWays Wizard, see SQLWays Wizard in User's Guide.
How to perform export and conversion with SQLWays Command Line
Launch Windows Command Line environment (cmd.exe on Windows NT/2000/XP or command.exe on Windows 9x). Type sqlways.exe, set required options and run the command. SQLways.exe will export and convert the source database with the specified options and create import scripts for the specified target database.
For more information about SQLWays Command Line and command options, see Command Line in User's Guide.
|
|