Red Gate forums :: View topic - Insert data from multiple sources
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 2
SQL Data Generator 2 forum

Insert data from multiple sources

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sreedhar kakade



Joined: 11 Dec 2013
Posts: 2

PostPosted: Wed Dec 11, 2013 4:24 am    Post subject: Insert data from multiple sources Reply with quote

I want to insert data into a table which has existing data. The source of additional data is coming from another SQL table and CSV file. Should I write a migration script?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 889
Location: Red Gate Software

PostPosted: Thu Dec 12, 2013 4:02 pm    Post subject: Reply with quote

Hi,
Thank you for your forum post.

The primary ideal behind SQL Data Generator is for the user to be able to generate realistic test data to populate selected tables or entire database. It is not a tool for merging data together.

However, you can add extra rows to the existing data. In the Table generation settings, uncheck the "Delete data from table before generation" check box and select the required data you wish to add using the "Use existing data source" option as the source of data.

Migration scripts are used with SQL Compare and SQL Source Control to prevent data loss when making a change to a specified table or merging / splitting tables or changing the data type of a column.

The migration feature has a new beta version called 'Migrations V2', if you wish to try ou the beta, please visit this web PAGE.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group