Differences

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

Link to this comparison view

knowledge-base:database-migration:ispirer-toolkit-faq:parallel-mode [2018/03/05 14:01]
 knowledge-base:database-migration:ispirer-toolkit-faq:parallel-mode [2023/11/27 13:29] (current)
Line 1: Line 1:
 +\\
 +[[https://​www.ispirer.com|Ispirer Website]]
 +[[https://​www.ispirer.com/​products/​migration-toolkit|Ispirer Toolkit Overview]]
 +[[https://​www.ispirer.com/​download/​download-demo|Free Trial]]
 +====== How to Run Ispirer SQLWays Wizard in Parallel Mode ======
  
 +===== When Can Parallel Mode Be Useful? =====
 +
 +Running the Ispirer SQLWays Wizard tool in a parallel mode can be beneficial in the following cases:
 +   * When migrating a huge database with a number of sql objects and data \\
 +   * Migrating a great number of databases \\
 +   * Migrating one large table. ​
 +
 +In these cases you may optimize your migration process by running the tool in a parallel mode. It may significantly increase the performance of your migration project.
 +
 +
 +===== How to Run in 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 Ispirer SQLWays Wizard, 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. 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.
 +
 +Also, please, note that each instance of Ispirer SQLWays Wizard should have its own project directory, as it is shown in the screenshot below:
 +
 +{{:​knowledge-base:​database-migration:​ispirer-toolkit-faq:​parall_1.jpg?​nolink|}}
 +
 +  * Migrating schema and data in separate processes
 +Step by Step guide on how to migrate set of objects and data in parallel mode can be found [[knowledge-base:​database-migration:​ispirer-toolkit-faq:​schema-and-data-migration|here]].\\
 +
 +  * Migrating a huge table
 +Step by Step guide on how to migrate one table in parallel mode can be found [[knowledge-base:​database-migration:​ispirer-toolkit-faq:​large-tables-migration|here]].\\
 +
 +===== Ispirer Recommendations =====
 +
 +- 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 have any additional questions on how the migration process can be optimized, please contact our support team: **__[[[email protected]]]__** ​
 +
 +\\