Select existing data from the database to create test data

Question

I have a SqlServer database, which I manually populated with some test data. Now I would like to extract this test data as insert statements and check it for initial control. The idea is that other team members should be able to create the same database, run the created insert scripts and have the same data for testing and development.

Is there a good tool for this? I am not looking for a tool to generate data, as discussed here .

Answer 1

The instance DB DB for SQL Server ( http://www.sqlmanager.net/en/products/mssql/extract ) seems to do what you want and it seems to be free.

Hope this helps,

Robin

Answer 2

If you need light weight, I would recommend sp_generate_inserts . This is a storage procedure that you can create in your database and pass many arguments to create insert statements for all data in the target table.

Answer 3

Red-Gate SQL Data Compare . . .

Answer 4

http://www.sqlscripter.com/

A new version of SQL Scripter (V2.1) was released last month.