Ispirer Ispirer
 

Differences

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

Link to this comparison view

sqlways:faq:migrate-to-existing-database [November 16, 2018, 08:40:58 AM]
darya.prikhodkina [How to Load the Data into Existing Table Structure?]
sqlways:faq:migrate-to-existing-database [November 16, 2018, 08:45:21 AM] (current)
darya.prikhodkina [How to Load the Data into Existing Table Structure?]
Line 14: Line 14:
 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 will transfer only data. 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 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 box 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 migrate only data, without the objects definitions. +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 box 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. 
  
 {{:sqlways:faq:no_ddl.png|}} {{:sqlways:faq:no_ddl.png|}}
sqlways/faq/migrate-to-existing-database.txt · Last modified: November 16, 2018, 08:45:21 AM by darya.prikhodkina
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement