Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

Conversion Results

The result of the Conversion stage is the set of files containing the converted information, either definition of the objects or their data, the batch commands for this converted data loading and some additional reporting, log and trace files, containing the information about the Conversion process. All these files stored in the “Export” folder:

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.


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

sqlways/users-guide/export-results.txt · Last modified: May 17, 2018, 12:47:38 PM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement