Insert data from multiple sources

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

Insert data from multiple sources

Postby sreedhar kakade » Wed Dec 11, 2013 4:24 am

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?
sreedhar kakade
 
Posts: 2
Joined: Wed Dec 11, 2013 4:21 am

Postby eddie davis » Thu Dec 12, 2013 4:02 pm

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
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 0 guests