Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

How to Optimize the Migration Process for Large tables

Regarding migration time. There are several that can be done to speed up the migration.
1. If there were no problems during export you can turn off trace mode. This will avoid trace generation and thus reduce migration time.
2. With our tool you can split the migration of data into parts and run them simultaneously. This can be done in two ways:
a. When you select “Data Options” tab for tables you’ll see Edit boxes for the start row and the number of rows to be exported (like below). By varying these numbers in separate instances of Wizard (like 1-5000, 5001-10000, etc.) you can run the migration of different parts of data simultaneously.


Please also note that you should uncheck “Generate DDL” option for processes other than first to avoid error of table existence. In this case only data will be migrated.


b. You can export data according to unique index or primary key or any other query condition. To perform this in Wizard please select “Use Query” in combo-box like below. With this option you can write your own query to select data. DDL statement will be generated according to selected columns. Table name will be the same as in FROM clause. But I advise you to create empty table first and then do the migration of data this way. You’ll get errors when trying to create table but data will be loaded fine.


For both these solutions please make sure that “Generate the DROP TABLE statement” check-box is unchecked at options page. Please also use separate project directories for each migration to prevent project files recreation.


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

sqlways/faq/optimize-migration-process-large-tables.txt · Last modified: March 20, 2013, 03:54:04 AM (external edit)
 
© 1999-2017, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement