Migration Execution

After the configuration is complete, you can run the migration. The Toolkit migration process consists of 2 phases: Conversion and Import. During the conversion phase, the tool extracts information about the objects chosen for this migration, converts them and generates the appropriate set of files. During the import phase, the tool tries to create all the converted objects and data in the target database.

In order to run the conversion process, click the “Start Conversion” button. Information about the conversion output is displayed dynamically in the “Conversion output” text field. After the conversion process is complete, you can run the import process to create the converted objects in the target database by clicking the “Start Import” button. If you want to view information about the import output, switch to the “Import output” tab.

By clicking the “Import Options Button”, you can check the “Start Import Automatically” checkbox before running the conversion, if you see that it may take much time due to the large number of objects and their complexity, and you are not going to monitor the entire conversion phase.

Once the conversion or conversion and import is complete, you can open the object for editing directly in the tool by clicking the “Edit” icon. The converted code will appear in a new tab of the tool and you will be able to edit it and save the changes. After editing all the necessary objects, you can import them again.

You can view all the generated files in the export directory by clicking the “Export Folder…” button. This button will open a folder with all conversion results along with log files: sqlways.log and sqlways_imp.log. The sqlways.log file stores detailed information about the conversion phase and the sqlways_imp.log file stores information about the import phase. These log files can be helpful for the Ispirer support team to understand the reasons for some issues you may face during the migration, if you provide a corresponding feedback.

Additionally, you can view the migration report by clicking the “Open Report…” button.

List of file extensions is as follows:

• *sqlways.log - the log file containing all information about the conversion process.
• *sqlways_imp.log - the log file containing all information about the import process.
• *sqlways.trc - the trace file containing detailed information about the conversion process. This file is created only if “Run in Trace Mode” option is switched on.
• *.bat - the batch file containing the commands to load the definitions of the exported object or its data. Each object has its own corresponding bat file.
  • sqlways_all.bat - the batch file containing the reference to each individual batch file. The references to the files are sorted according to the relationships between the objects exported from the source database.
• *.txt - the file with the data from the appropriate table. Each table have its corresponding txt file after the export stage if the table contained the data in the source database.
  • *_del.txt - the additional file with the data from the appropriate table. This file is created only if the exported data contains the column and/or line delimiters, that are used by the native command line tool of the destination database for data loading.
• *.sql - the file with the definitions of the exported sql object. Each successfully exported object have its corresponding sql file after the export stage.
  • _ddl.sql - the file with the definitions of the exported table. Each successfully exported table have its corresponding “_ddl.sql” file after the export stage.
  • _idx.sql - the file with the definitions of the exported indexes. The file is created only if some indexes were created on a table in the source database.
  • _cns.sql - the file with the definitions of the exported constraints. The file is created only if “Import Order” option was set to “Fast”, and constraints should be loaded in target database after the data migration.
  • _tab.sql - the file with the definitions of the exported table, when option “Migration Sequence” is set to “Fast”. Each successfully exported table have its corresponding “_tab.sql” file after the export stage.
  • SWF_*.sql, SWT_*.sql, SWP_*.sql - files that contain definitions of the objects generated by the migration tool in order to emulate source database logic in destination database. ( SWP - means SQLWays Stored Procedure, SWT - means SQLWays Trigger, SWF - means SQLWays Function and etc.)

Import options on this window defines the types of the objects that will be loaded into the target database during the import:
“Full” - Will do the import of all the converted objects (Table definitions, data, constraints, indexes).
“DDL” - Option that defines whether the import of converted table definitions will be done.
“DATA” - Option that defines whether the import of converted data will be done.
“Constraints” - Option that defines whether the import of converted constraints will be done.
“Indexes” - Option that defines whether the import of converted Indexes will be done.
“Views” - Option that defines whether the import of converted Views will be done.
“Business Logic Objects” - Option that defines whether the import of converted Business Logic Objects will be done.
“Triggers” - Option that defines whether the import of converted Triggers will be done.
“User Defined Types” - Option that defines whether the import of converted User Defined Types will be done.
“Sequences” - Option that defines whether the import of converted Sequences will be done.
“Synonyms” - Option that defines whether the import of converted Synonyms will be done.
“Generated Objects” - Option that defines whether the import of additionally generated objects will be done. ( Objects that are generated by SQLWays Wizard automatically in order to emulate the logic of some features of the source database. Names of such objects starts with prefixes SWT_ or SWP_ or SWF_ ).

“Start Import Automatically” - If this option is checked import process will be started automatically right after the “Conversion”. And user don't have to click “Start Import” button.

This feature allows to control the import process and define the required order of the import process as your needs.

NOTE: This option doesn't influence on the conversion process. And Ispirer SQLWays Wizard will extract and convert all the objects (DDLs, Constraints, Indexes and additionally generated objects) and data. But during the import process only selected objects will be loaded.

Next Page: Migration Reports
Previous Page: Summary Page

If you have any questions or face any difficulties, please contact our support team: support@ispirer.com