Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
faq:migration-toolkit:how-to-run-in-parallel-mode [2019/06/12 00:36]
127.0.0.1 external edit
faq:migration-toolkit:how-to-run-in-parallel-mode [2019/07/25 10:15]
darya.prikhodkina
Line 3: Line 3:
 ===== When Parallel Mode Can Be Useful ===== ===== When Parallel Mode Can Be Useful =====
  
-Running ​the Ispirer SQLWays Wizard tool in a parallel mode can be quite useful when: +Running Ispirer SQLWays Wizard tool in a parallel mode can be quite useful when: 
-   ​* ​When migrating ​a huge database with a great number of sql objects and data \\+   ​* ​Migrating ​a huge database with a great number of SQL objects and data \\
    * Migrating a great number of databases \\    * Migrating a great number of databases \\
    * Migrating one very huge table. ​    * Migrating one very huge table. ​
  
-In these cases you may optimize ​your migration process by running the tool in a parallel mode. It may significantly ​increase performance of your migration ​project.+In these cases you may optimize ​the migration process by running the tool in a parallel mode. It may significantly ​speed up the migration.
  
  
-===== How to Run in a Parallel Mode =====+===== How to Run Migration ​in a Parallel Mode =====
  
-To migrate in a parallel mode you just need to run several instances of the Ispirer SQLWays Wizard tool. For example, ​launching ​the first process of the Ispirer SQLWays Wizardspecify the set of objects that should be migrated during the first process. Then launch the same tool again and specify another set of objects or another database for conversion. ​And in the same way you can run as many processes as you need, but to do this, it's important to have powerful working environment to be able to run more than 5 processes of Ispirer SQLWays Wizard.+To migrate in a parallel mode you just need to run several instances of Ispirer SQLWays Wizard tool. For example, ​launch ​the first process of Ispirer SQLWays Wizard ​and specify the set of objects that should be migrated during the first process. Then launch the same tool again and specify another set of objects or another database for conversion. ​So you can run as many processes as required, but please note that it's important to have powerful working environment to be able to run more than 5 processes of Ispirer SQLWays Wizard.
  
-Also, please, ​note that each instance of Ispirer SQLWays Wizard should have its own project directory, like it is shown on the screenshot:+Please also note that each instance of Ispirer SQLWays Wizard should have its own project directory, like it is shown on the screenshot:
  
 {{:​faq:​migration-toolkit/​parallel.png?​1000|}} ​ {{:​faq:​migration-toolkit/​parallel.png?​1000|}} ​
Line 23: Line 23:
  
 - We recommend to divide the whole migration scope into the sets of objects that are independent from each other.\\ - We recommend to divide the whole migration scope into the sets of objects that are independent from each other.\\
-- If you are migrating a huge database or one table in separate processes, we recommend ​that the size of the data should be approximately equal in each migration set.\\+- If you are migrating a huge database or one table in separate processes, we recommend ​to divide ​the data into approximately equal parts for each migration set.\\
 - Step by Step guide on how to migrate one table in parallel mode can be found here: **__[[faq:​migration-toolkit/​optimize-migration-process-large-tables]]__** \\ - Step by Step guide on how to migrate one table in parallel mode can be found here: **__[[faq:​migration-toolkit/​optimize-migration-process-large-tables]]__** \\
-- If you have any additional questions on how the migration process can be optimized, pleasecontact our support team: **__[[[email protected]]]__** ​+- If you have any additional questions on how the migration process can be optimized, please contact our support team: **__[[[email protected]]]__** ​
  
 \\ \\