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:toolkit-overview [May 17, 2018, 12:54:30 PM] alexandr.kirpichnysqlways:users-guide:toolkit-overview [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]]
- +
 ====== 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 11:
    * 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 the tool connects to a 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
  
-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 connectionextracts 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+And the second step is Import. During an Import stage SQLWays Wizard connects to a target database using target database client and its command line native utilities (psql.exemysql.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
  
-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. +Please, find below a simple database migration process schema of Ispirer SQLWays Wizard Tool:
  
-Simple schema of the database migration process using the Ispirer SQLWays Wizard Tool:+{{:sqlways:users-guide:migrating_database_using_ispirer_mnmtk.png?1280|}}
  
-{{:sqlways:users-guide:migr_schema.png?900|}} 
  
  
-\\ 
-[[http://www.ispirer.com|Ispirer Home Page]] 
-[[http://www.ispirer.com|Ispirer SQLWays Migration Product Page]] 
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]] 

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