Ispirer Migration Knowledge Base

User Tools

Site Tools

You are here: Ispirer Migration Knowledge Base » Ispirer Migration Knowledge Base » faq » How to Use the Ispirer SQLWays Wizard Tool

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:faq:how-to-use-sqlways-wizard [April 09, 2019, 10:26:17 AM] – [Other Questions] darya.prikhodkinasqlways:faq:how-to-use-sqlways-wizard [May 31, 2023, 05:28:08 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/products|Ispirer SQLWays 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]]
 ====== How to Use the Ispirer SQLWays Wizard Tool ====== ====== How to Use the Ispirer SQLWays Wizard Tool ======
  
Line 10: Line 9:
 Note: Always run the SQLWays Wizard Tool using "as Administrator" option. You can do it in Windows Search panel, like it is done on the screenshot: Note: Always run the SQLWays Wizard Tool using "as Administrator" option. You can do it in Windows Search panel, like it is done on the screenshot:
  
-{{:sqlways:faq:sqlways_admin.png|}}+{{:sqlways:faq:sqlways_admin_10.png|}}
  
-Or you can go to the installation directory, right click on the icon and choose "Run as Administrator". \\ By default installation directory look like "**C:\Program Files (x86)\Ispirer\MnMTK2017**". \\ Please see the screenshot for your reference:+Or you can go to the installation directory, right click on the icon and choose "Run as Administrator". \\ By default installation directory look like "**C:\Program Files\Ispirer\IspirerToolkit10**". \\ Please see the screenshot for your reference:
  
-{{:sqlways:sqlways_admin2.png|}}+{{:sqlways:faq:sqlways_admin2_10.png|}}
  
 In other case we can't guarantee that the tool will be able to extract all the required information from source database and store it in files on the local machine, where you running the assessment process. In other case we can't guarantee that the tool will be able to extract all the required information from source database and store it in files on the local machine, where you running the assessment process.
Line 22: Line 21:
 On the first page of the SQLWays Wizard tool we need to enter the license information and provide the project directory.  On the first page of the SQLWays Wizard tool we need to enter the license information and provide the project directory. 
  
-{{:sqlways:faq:welcome.png|}}+{{:sqlways:faq:welcome_10.png|}}
  
 ==== 1.1 Enter the License Information ==== ==== 1.1 Enter the License Information ====
Line 28: Line 27:
 To register the tool we need to click "Enter License" button and in the opened window click "Read from file". To register the tool we need to click "Enter License" button and in the opened window click "Read from file".
  
-{{:sqlways:faq:read_file.png|}}+{{:sqlways:faq:read_file_10.png|}}
  
 After that we need to find the file with the license and open it. After that we need to find the file with the license and open it.
  
-{{:sqlways:faq:open_license.png|}}+{{:sqlways:faq:open_license_10.png|}}
  
 Then registration name and registration number should appear in appropriate windows and you will need to click "Register": Then registration name and registration number should appear in appropriate windows and you will need to click "Register":
  
-{{:sqlways:faq:reg_license.png|}}+{{:sqlways:faq:reg_license_102.png|}}
  
 ==== 1.2 Project Directory ==== ==== 1.2 Project Directory ====
Line 42: Line 41:
 After the tool registration we need to provide the project directory. In this directory our tool will generate project file that will store information about the current migration process. After the tool registration we need to provide the project directory. In this directory our tool will generate project file that will store information about the current migration process.
  
-{{:sqlways:faq:proj_dir.png|}}+{{:sqlways:faq:proj_dir_10.png|}}
  
  
Line 53: Line 52:
 Then we need to choose the ODBC connection to the source database that should be migrated. And specify a user and a password that will be used to connect to the source database. Then we need to choose the ODBC connection to the source database that should be migrated. And specify a user and a password that will be used to connect to the source database.
  
-{{:sqlways:faq:source.png|}}+{{:sqlways:faq:source_10.png|}}
  
  
-**__Please note:__** Our tool works using the ODBC connection to the source database only! It means that before using the SQLWays Wizard tool you need to install the ODBC driver and tune the ODBC connection to the database that should be migrated. Some additional information about the ODBC driver installation and configuration can be found on that page: **__[[http://wiki.ispirer.com/sqlways/users-guide/setting-up-database-connection|Setting Up Database Connection]]__**+**__Please note:__** Our tool works using the ODBC connection to the source database only! It means that before using the SQLWays Wizard tool you need to install the ODBC driver and tune the ODBC connection to the database that should be migrated. Some additional information about the ODBC driver installation and configuration can be found on that page: **__[[https://wiki.ispirer.com/sqlways/users-guide/setting-up-database-connection|Setting Up Database Connection]]__**
  
-**__Please note:__** User that we specify on that page should have appropriate rights to make selects from system tables from your source database. More information about source database user privileges can be found on that page: **__[[http://wiki.ispirer.com/sqlways/users-guide/check-list/setting-up-source-user-privileges| Source User Privileges]]__**+**__Please note:__** User that we specify on that page should have appropriate rights to make selects from system tables from your source database. More information about source database user privileges can be found on that page: **__[[https://wiki.ispirer.com/sqlways/users-guide/check-list/setting-up-source-user-privileges| Source User Privileges]]__**
  
  
-===== 3. Choose a Target Database =====+===== 3. Choose a Target Database and Specify Import Options=====
  
 To be able to make an import into the target database, we need to choose the required database from the list of the supported databases, on a "Choose a Target Database" page. And specify correct information about the target database, for example, server name, database name, user name and a password.  To be able to make an import into the target database, we need to choose the required database from the list of the supported databases, on a "Choose a Target Database" page. And specify correct information about the target database, for example, server name, database name, user name and a password. 
  
-{{:sqlways:faq:target_db.png|}}+Then we need to specify the **Bin Directory**. This is the path where native utility of the target database is stored on your local machine where Ispirer Migration and Modernization Toolkit is installed. It means that to be able to make an import into the target database you need to have native utility installed on the machine where you run the conversion. 
 + 
 +{{:sqlways:faq:target_db_102.png|}} 
 + 
 +For more information about the databases and their native utilities, that will be used by our tool, please refer to that link: 
 + 
 +**__[[https://wiki.ispirer.com/sqlways/users-guide/wizard/specify-import-opt#bin_directory|Databases and their native utilities]]__**
  
 This information will be used by our tool to generate correct command lines to the native utilities of the target database. This information will be used by our tool to generate correct command lines to the native utilities of the target database.
Line 73: Line 78:
 Next step is to specify objects for conversion from the list of objects that our tool was able to extract from source database. To select objects you can just drag-n-drop the required objects to the right pane of the tool. Or you can select objects using buttons at the bottom of the tool: Next step is to specify objects for conversion from the list of objects that our tool was able to extract from source database. To select objects you can just drag-n-drop the required objects to the right pane of the tool. Or you can select objects using buttons at the bottom of the tool:
  
-{{:sqlways:faq:choose_obj.png|}}+{{:sqlways:faq:choose_obj_10.png|}}
  
 === Refresh Object List === === Refresh Object List ===
Line 79: Line 84:
 If during the migration process the list of objects was updated, for example some additional objects were created or dropped from the database, you can refresh the list of extracted objects. To do that just right click on the required object type or on the "Database" branch and click "Refresh" button, like it is shown on the screenshot: If during the migration process the list of objects was updated, for example some additional objects were created or dropped from the database, you can refresh the list of extracted objects. To do that just right click on the required object type or on the "Database" branch and click "Refresh" button, like it is shown on the screenshot:
  
-{{:sqlways:users-guide:wizard:refresh_obj.png|}}+{{:sqlways:faq:refresh_obj_10.png|}}
 ===== 5. Specify DDL and Data Options ===== ===== 5. Specify DDL and Data Options =====
  
 If required, you can specify different options that can be used to customize the conversion process. These options can be found on the "Specify DDL and Data Options" page: If required, you can specify different options that can be used to customize the conversion process. These options can be found on the "Specify DDL and Data Options" page:
  
-{{:sqlways:faq:ddl_data_options.png|}}+{{:sqlways:faq:ddl_data_options_102.png|}}
  
  
Line 91: Line 96:
 After that, you will need to specify Export Directory. This is the directory where our tool will put all the generated files, like sql files with the converted code, txt files with the data, bat or sh files with the commands to the native utilities. After that, you will need to specify Export Directory. This is the directory where our tool will put all the generated files, like sql files with the converted code, txt files with the data, bat or sh files with the commands to the native utilities.
  
-{{:sqlways:faq:exp_dir.png|}}+{{:sqlways:faq:exp_dir_10.png|}}
  
  
-===== 7. Specify Import Options ===== +===== 7. Running the Migration =====
- +
-Then we need to specify the **Bin Directory**. This is the path where native utility of the target database is stored on your local machine where Ispirer Migration and Modernization Toolkit is installed. It means that to be able to make an import into the target database you need to have native utility installed on the machine where you run the conversion. +
- +
-{{:sqlways:faq:bin_dir.png|}} +
- +
-For more information about the databases and their native utilities, that will be used by our tool, please refer to that link: +
- +
-**__[[http://wiki.ispirer.com/sqlways/users-guide/wizard/specify-import-opt#bin_directory|Databases and their native utilities]]__** +
- +
- +
-===== 8. Running the Migration =====+
  
 After all these steps we need to run the migration. Migration process itself consist of two steps: "Conversion" and "Import". During the conversion step our tool extracts information about the objects specified for a conversion, converts them and generates appropriate set of files. During the import step our tool tries to create all the converted objects and data into the target database. After all these steps we need to run the migration. Migration process itself consist of two steps: "Conversion" and "Import". During the conversion step our tool extracts information about the objects specified for a conversion, converts them and generates appropriate set of files. During the import step our tool tries to create all the converted objects and data into the target database.
  
-==== 8.1 Conversion Step ====+==== 7.1 Conversion Step ====
  
 To run the conversion process, we need to click "Start Conversion" button on the "Conversion" tab on the "Migration Status" page: To run the conversion process, we need to click "Start Conversion" button on the "Conversion" tab on the "Migration Status" page:
  
-{{:sqlways:faq:conversion.png|}}+{{:sqlways:faq:conversion_10.png|}}
  
-==== 8.2 Import Step ====+==== 7.2 Import Step ====
  
 After the conversion process is finished, we need to run the import process. So we need to go to the "Import" tab and click "Start Import" button and import process will be initiated. After the conversion process is finished, we need to run the import process. So we need to go to the "Import" tab and click "Start Import" button and import process will be initiated.
  
-{{:sqlways:faq:import.png|}}+{{:sqlways:faq:import_10.png|}}
  
-==== 8.3 Review the Results ====+==== 7.3 Review the Results ====
  
 After the migration process you can review all the generated files in the export directory by clicking "View Export" button on the "Conversion" tab. And this button will open a folder that store all the converted results together with the log files - **sqlways.log** and **sqlways_imp.log** files. Sqlways.log files stores detailed information about the conversion step and sqlways_imp.log file stores information about the import process. After the migration process you can review all the generated files in the export directory by clicking "View Export" button on the "Conversion" tab. And this button will open a folder that store all the converted results together with the log files - **sqlways.log** and **sqlways_imp.log** files. Sqlways.log files stores detailed information about the conversion step and sqlways_imp.log file stores information about the import process.
Line 130: Line 124:
  
 These steps describes how to make an import process into the target database. If you have some questions or face with some difficulties please contact our support team and provide log files ( **sqlways.log** and **sqlways_imp.log** files ) together with detailed description of the case you faced with: [[[email protected]]] These steps describes how to make an import process into the target database. If you have some questions or face with some difficulties please contact our support team and provide log files ( **sqlways.log** and **sqlways_imp.log** files ) together with detailed description of the case you faced with: [[[email protected]]]
- 
- 
-\\ 
-[[http://www.ispirer.com|Ispirer Home Page]] 
-[[http://www.ispirer.com/products|Ispirer SQLWays Product Page]] 
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]] 
© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.