Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
faq:migration-toolkit:migrate-to-existing-database [2019/07/25 10:46] darya.prikhodkina |
faq:migration-toolkit:migrate-to-existing-database [2019/07/25 11:05] darya.prikhodkina |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ===== How to Overwrite Existing Table Structure ===== | ===== How to Overwrite Existing Table Structure ===== | ||
| - | If you want to overwrite the table definitions, you can specify generate DROP TABLE statements option in SQLWays Wizard. Please use the [[sqlways:users-guide/wizard/specify-ddl-data/db_options/ddl_options/sql_scripts#generate_the_drop_table_statement|"Generate the drop table statements"]] option. | + | If you want to overwrite the table definitions, you can specify "Generate DROP TABLE statements" option in SQLWays Wizard. Please refer to the [[sqlways:users-guide/wizard/specify-ddl-data/db_options/ddl_options/sql_scripts#generate_the_drop_table_statement|"Generate the drop table statements"]] page. |
| ===== How to Load the Data into Existing Table Structure ===== | ===== How to Load the Data into Existing Table Structure ===== | ||
| Line 14: | Line 14: | ||
| - | Before running the migration please also make sure that the "Export Data" option is enabled. To do that, please click the "Data" tab on the same page: | + | Before running the migration please also make sure that the "Export Data" option is enabled. To check it, please click the "Data" tab on the same page: |
| {{:faq:migration-toolkit/data_only.png|}} | {{:faq:migration-toolkit/data_only.png|}} | ||
| Line 21: | Line 21: | ||
| **Ispirer Note:**\\ | **Ispirer Note:**\\ | ||
| - | Please note, when running data only migration, you need to be sure that there are no constraints in the database that will not allow to push the data into tables in your target database. Otherwise, you will have to disable such constraints in your database before the migration and enable them after the migration process is finished. | + | Please note, that when running data only migration, you need to be sure that there are no constraints in the database that will not allow to push the data into tables in your target database. Otherwise, you will have to disable such constraints in your database before the migration and enable them after the migration process is finished. |
| \\ | \\ | ||