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
Previous revision
Next revision Both sides next revision
faq:migration-toolkit:optimize-migration-process-large-tables [2019/07/25 11:18]
darya.prikhodkina
faq:migration-toolkit:optimize-migration-process-large-tables [2019/07/25 11:27]
darya.prikhodkina
Line 13: Line 13:
 {{:​faq:​migration-toolkit/​data_options.png|}}\\ {{:​faq:​migration-toolkit/​data_options.png|}}\\
  
-Please also note that you should uncheck “Generate DDL” option for processes other than the first one to avoid error of table existence. In this case only data will be migrated.+Please also note that you should uncheck “Generate DDL” option for the processes other than the first one in order to avoid the error of table existence. In this case only data will be migrated.
  
 {{:​faq:​migration-toolkit/​ddl_options.png|}}\\ {{:​faq:​migration-toolkit/​ddl_options.png|}}\\
Line 22: Line 22:
 You can export data according to unique index or primary key or any other query condition. To perform this in SQLWays Wizard please select “Use Query” in combo-box shown below. ​ You can export data according to unique index or primary key or any other query condition. To perform this in SQLWays Wizard please select “Use Query” in combo-box shown below. ​
 Using this option you can write your own query to select data. DDL statement will be generated according to the selected columns. ​ Using this option you can write your own query to select data. DDL statement will be generated according to the selected columns. ​
-Table name will be the same as in FROM clause. But we advise you to create empty tables first and then to perform the migration of data this way.  +Table name will be the same as in FROM clause. But we advise you to create empty tables first and then to perform the migration of data.  
-You’ll get errors when trying to create a table but data will be loaded ​fine.+You’ll get errors when trying to create a table but data will be loaded ​correctly.
  
 {{:​faq:​migration-toolkit/​use_queries.png|}}\\ {{:​faq:​migration-toolkit/​use_queries.png|}}\\
  
-For both these solutions please make sure that the “Generate the DROP TABLE statement” check-box ​is unchecked at the options page. Please also use separate project directories for each migration to prevent project files recreation.+When using any of these solutions please make sure that the “Generate the DROP TABLE statement” check-box ​from the options page is unchecked. Please also use separate project directories for each migration to prevent project files re-creation.
  
-If you face any difficulties or have any other questions, please contact our support team: [[[email protected]]]+If you face any difficulties or have any questions, please contact our support team: [[[email protected]]]
  
 \\ \\