Ispirer Ispirer
 

Differences

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

Link to this comparison view

sqlways:users-guide:toolkit-overview [May 17, 2018, 12:54:30 PM]
alexandr.kirpichny
sqlways:users-guide:toolkit-overview [May 24, 2018, 07:05:22 AM] (current)
vera.bonda
Line 7: Line 7:
 ====== Ispirer Migration and Modernization Toolkit Description ====== ====== Ispirer Migration and Modernization Toolkit Description ======
  
-Ispirer Migration and Modernization Toolkit was designed to simplify the database and application migration. This toolkit consists of 3 tools:+Ispirer Migration and Modernization Toolkit was designed to simplify database and application migration. This toolkit consists of 3 tools:
  
    * [[https://wiki.ispirer.com/sqlways/faq/how-to-use-sqlways-wizard|Ispirer SQLWays Wizard]]    * [[https://wiki.ispirer.com/sqlways/faq/how-to-use-sqlways-wizard|Ispirer SQLWays Wizard]]
Line 13: Line 13:
    * Ispirer Migration Commander    * Ispirer Migration Commander
  
-Main tool that is used for database migration purposes is Ispirer SQLWays Wizard tool. The idea of this tool is that it is able to connect to the source database using the ODBC Connection. Besides, SQLWays Wizard is able to connect to source database on the local server as well as on the remote server, using an ODBC connection. +Ispirer SQLWays Wizard is the main tool, which is used for database migration purposes. The tool is able to connect to source database on local server as well as on remote server, using an ODBC connection. 
  
-The whole migration process is performed in two steps –°onversion and Import. The first step is Conversion. During the Conversion stage our tool connects to the source database with the ODBC connection, extracts all the required information about the objects that were specified for the Conversion process and converts them. Converted sql code is stored in the sql files on the local machine, where the Wizard is running. +The whole migration process is performed in two steps–°onversion and Import. The first step is Conversion. During the Conversion stage the tool connects to source database with an ODBC connection, extracts all the required information about the objects that were specified for the Conversion process and converts them. The converted SQL code is stored in the SQL files on the local machine, where the Wizard is running. 
  
-And the second step is Import. During the Import stage SQLWays Wizard connects to the target database using target database client and its command line native utilities (psql.exe, mysql.exe, sqlcmd.exe, sqlplus.exe and others). And using these native utilities it loads all the converted sql code and extracted data into the target database. +And the second step is Import. During an Import stage SQLWays Wizard connects to target database using target database client and its command line native utilities (psql.exe, mysql.exe, sqlcmd.exe, sqlplus.exe and others). Using these native utilities it loads all the converted SQL code and extracted data into the target database. 
  
-Simple schema of the database migration process using the Ispirer SQLWays Wizard Tool:+Please, find below a simple database migration process schema of Ispirer SQLWays Wizard Tool:
  
 {{:sqlways:users-guide:migr_schema.png?900|}} {{:sqlways:users-guide:migr_schema.png?900|}}
sqlways/users-guide/toolkit-overview.1526561670.txt.gz · Last modified: May 17, 2018, 12:54:30 PM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement