Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
sqlways:users-guide:export-results [May 17, 2018, 12:47:38 PM] alexandr.kirpichnysqlways:users-guide:export-results [May 31, 2023, 05:28:12 PM] (current) – external edit 127.0.0.1
Line 1: Line 1:
 \\ \\
-[[http://www.ispirer.com|Ispirer Home Page]] +[[https://www.ispirer.com|Ispirer Website]] 
-[[http://www.ispirer.com|Ispirer SQLWays Migration Product Page]] +[[https://www.ispirer.com/products/migration-toolkit|Ispirer Toolkit Overview]] 
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]+[[https://www.ispirer.com/download/download-demo|Free Trial]]
 ===== Conversion Results ===== ===== 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: 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:
  
-{{:sqlways:users-guide:view_export.png?|}} +{{:sqlways:users-guide:status.png|}}
  
 List of file extensions is as follows: List of file extensions is as follows:
Line 22: Line 22:
     * **_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.      * **_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.     * **_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.)
          
 \\ \\
-[[http://www.ispirer.com|Ispirer Home Page]] + 
-[[http://www.ispirer.com|Ispirer SQLWays Migration Product Page]] +===== Import Options ===== 
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]+ 
 +{{:sqlways:users-guide:imp_options.png|}} 
 + 
 +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\\ 
 +"**Constraints**" -  Option that defines whether the import of converted constraints will be done\\ 
 +"**DATA**" -  Option that defines whether the import of converted data will be done\\ 
 +"**Indexes**" -  Option that defines whether the import of converted Indexes 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 er your needs. 
 + 
 +\\ 
 + 
 +**Please 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. 
 +  
 + 
 + 
 + 
 + 

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.