Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next 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] darya.prikhodkina |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== How to Convert and Import Database in Command Line Mode ====== | + | ====== How to Convert and Import a 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 required, it 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 tool, select all the required objects for conversion and on the "Review the Selections" page, you will see the generated command line: | + | The easiest way to prepare a 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 a 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]]]__** |
| \\ | \\ | ||