Differences

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

--- faq:migration-toolkit:migrate-to-existing-database [2019/07/25 11:05]
darya.prikhodkina
+++ — (current)
@@ Line 1: / Line 1: @@
-====== How to Migrate Data into Existing Database ======
-===== 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 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 =====
-To load the data into existing table structure without recreating it, uncheck the  [[sqlways:users-guide/wizard/specify-ddl-data/table_options/ddl_options/sql_script#generate_ddl|"Generate DDL"]] option. In this case, SQLWays Wizard will transfer only data.
-You can find this option on the "Specify DDL and Data Options" page. You just need to click on "Tables" branch and select "Generation Options" in the dropdown list of the "DDL" tab. After that please uncheck "Generate DDL" option and run the migration. In this case SQLWays Wizard tool will extract, convert and load only data, without the objects definitions.
-{{:faq:migration-toolkit/no_ddl.png|}}
-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|}}
-\\
-**Ispirer Note:**\\
-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.
-\\
-If you have any other questions, please feel free to contact us: [[[email protected]]]
-\\
-----
-=== More about Ispirer Systems ===
-[[https://www.ispirer.com|Ispirer Home Page]]
-[[https://www.ispirer.com/products/database-migration|Database Migration]]
-[[https://www.ispirer.com/application-conversion|Application Conversion]]
-[[https://www.ispirer.com/download|Downloads]]