SQLWays (Beta) Web: Running SQLWays in Parallel Mode

Running SQLWays Beta (web based) in parallel mode can be advantageous in the following scenarios:

• migrating a large database containing a significant number of SQL objects and substantial volumes of data
• migrating multiple databases simultaneously
• migrating a single very large table

In such cases, parallel execution allows you to optimize the migration process and can significantly improve the overall performance and throughput of the migration project.

To perform a migration in parallel mode, you can switch between multiple projects in the SQLWays Beta (web-based) tool. For example, you can create an initial project, specify the set of database objects to be migrated in that process, and start the conversion. You can then create an additional project, assign a different set of objects or another database for conversion, and start the conversion process as well.

You can switch between projects by simply selecting the required project from the project list.

This approach can be reused as needed, allowing multiple migration processes to run in parallel. However, it is important to ensure that your working environment has sufficient system resources to support multiple concurrent conversion processes in SQLWays Beta (web-based). Running more than five parallel conversion processes typically requires a powerful hardware configuration.

Please also note that each project in SQLWays Beta (web-based) uses its own dedicated migration project directory, as shown in the screenshot below:

Step by Step guide on how to migrate set of objects and data in parallel mode can be found here.

• 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.

Database Migration Guide

More Tips and Tricks

If you have any questions or face any difficulties, please contact our support team at support@ispirer.com