Differences

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

Link to this comparison view

Both sides previous revision Previous revision
faq:migration-toolkit:export-import-command-line-mode [2019/06/13 17:43]
127.0.0.1 external edit
faq:migration-toolkit:export-import-command-line-mode [2019/07/19 12:19] (current)
darya.prikhodkina
Line 1: Line 1:
-====== How to Convert and Import Database in Command Line Mode ======+====== How to Convert and Import ​Database in Command Line Mode ======
    
 Ispirer Migration and Modernization Toolkit allows you to convert and load converted database via command line or shell script. ​ Ispirer Migration and Modernization Toolkit allows you to convert and load converted database via command line or shell script. ​
Line 7: Line 7:
 First of all we need to open a command line window by running **Start -> SQLWays 8.x -> SQLWays Command Line** or **Start -> Run -> cmd.exe** ​ First of all we need to open a command line window by running **Start -> SQLWays 8.x -> SQLWays Command Line** or **Start -> Run -> cmd.exe** ​
  
-=== Prepare ​Command Line ===+=== Preparing ​Command Line ===
  
-To convert database objects we need to use **sqlways.exe** command line utility. So we have to prepare appropriate command line for this command line tool.+To convert database objects we need to use **sqlways.exe** command line utility. So we have to prepare ​an appropriate command line for this command line tool.
  
 Command line may look as follows: Command line may look as follows:
Line 22: Line 22:
 Here is the list of parameters used in the provided command line:  Here is the list of parameters used in the provided command line: 
  
-  * **sqlways.exe** ​ -  ​this is the name of the utility that performs the conversion. If required it can be specified with the full path to the utility.+  * **sqlways.exe** ​ -  the name of the utility that performs the conversion. If requiredit can be specified with the full path to the utility.
   * **/​d** ​ -  specifies the ODBC Data Source Name (DSN) to connect to the source database. Articles on how to tune the ODBC Connection to your source database can be found here: [[http://​wiki.ispirer.com/​sqlways/​users-guide/​setting-up-database-connection| How to Tune ODBC Connection]].   * **/​d** ​ -  specifies the ODBC Data Source Name (DSN) to connect to the source database. Articles on how to tune the ODBC Connection to your source database can be found here: [[http://​wiki.ispirer.com/​sqlways/​users-guide/​setting-up-database-connection| How to Tune ODBC Connection]].
   * **/​U** ​ -  specifies the user name for the source connection.   * **/​U** ​ -  specifies the user name for the source connection.
Line 40: Line 40:
  
  
-=== The Easiest Way To Get The Command Line === +=== The Easiest Way to Get the Command Line === 
  
-The easiest way to prepare correct command line is to run SQLWays Wizard toolselect all the required objects for conversion ​and on the "​Review the Selections"​ pageyou will see the generated command line:+The easiest way to prepare ​correct command line is to run SQLWays Wizard tool and select all the required objects for conversion, so that on the "​Review the Selections"​ page you will see the generated command line:
  
 {{:​faq:​migration-toolkit/​summary.png|}} {{:​faq:​migration-toolkit/​summary.png|}}
Line 51: Line 51:
 === Run the Prepared Command Line === === Run the Prepared Command Line ===
  
-After we prepared ​the command line with appropriate set of options we need to run it in the command line prompt.+After we prepared ​command line with appropriate set of options we need to run it in the command line prompt.
  
 {{:​faq:​migration-toolkit/​cmd_run.png|}} {{:​faq:​migration-toolkit/​cmd_run.png|}}
Line 62: Line 62:
  
  
-===== Import ​Into The Target Database =====+===== Import ​into the Target Database =====
  
-During the "​Conversion"​ process SQLWays.exe tool generates all the scripts required for the import and places them in the appropriate order so that to save the referential integrity.+During the "​Conversion"​ process SQLWays.exe tool generates all the scripts required for import and places them in the appropriate order so that to save the referential integrity.
  
-So, to make import we just need to run the generated "​sqlways_all.bat"​ file. To do that, we need to go to the output directory (directory that we have specified in the **/DIR** option) and run this file.+To make import we just need to run the generated "​sqlways_all.bat"​ file. To do that, we need to go to the output directory (directory that we have specified in the **/DIR** option) and run this file.
  
 Please see the screenshot for your reference: Please see the screenshot for your reference:
Line 84: Line 84:
 A more detailed list of command line options can be found here: **__[[http://​wiki.ispirer.com/​sqlways/​command-line/​options|Command Line Options]]__** A more detailed list of command line options can be found here: **__[[http://​wiki.ispirer.com/​sqlways/​command-line/​options|Command Line Options]]__**
 \\ \\
-If you have any questions ​on how to run the migration in batch mode, please contact our technical team: **__[[[email protected]]]__**+If you have any questions ​about how to run the migration in batch mode, please contact our technical team: **__[[[email protected]]]__**
  
 \\ \\