Is there a tool that allows me to create a sql populate script for a table using its current data?
views:
102answers:
4
A:
You could look at purchasing the Data Generator by Red-Gate which can create random sets of data based on your database schema.
Note: I'm not sure if the tool will generate data based on your current data though
Kane
2010-01-18 12:25:53
No, it won't - it's a test data generator which will create new test data for your tables, based on some data repositories. But it definitely does not script out your current data in your tables.
marc_s
2010-01-18 12:58:42
+1
A:
Maybe this is just enough for you: http://snipplr.com/view/12003/generate-insert-statements/
Scoregraphic
2010-01-18 12:28:20
A:
You can do it with Database Publishing Wizard. Here is a tutorial: Generate Script with Data from Database – Database Publishing Wizard
Giorgi
2010-01-18 12:28:25
+1
A:
Check out the SSMS Addins (for both SSMS 2005 and 2008):
One of the tools included in the "DataScripter" which will script out INSERT statements for the table(s) you want to.
marc_s
2010-01-18 12:34:05