<p>I have a SqlServer database that I've manually filled with some test data. Now I'd like to extract this test data as insert statements and check it in to source 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 to test and develop on.</p>

<p>Is there a good tool out there to do this? I'm <strong>not</strong> looking for a tool to generate data as discussed <a href="https://stackoverflow.com/questions/16317/creating-test-data-in-a-database">here</a>.</p>

[{'answer_id': 24244, 'author': 'robintw', 'author_id': 1912, 'author_profile': 'https://Stackoverflow.com/users/1912', 'pm_score': 2, 'selected': True, 'text': '<p>EMS DB Extract for SQL Server (<a href="http://www.sqlmanager.net/en/products/mssql/extract" rel="nofollow noreferrer">http://www.sqlmanager.net/en/products/mssql/extract</a>) seems to do what you want, and it seems to be free.</p>\n\n<p>Hope this helps,</p>\n\n<p>Robin</p>\n'}, {'answer_id': 24246, 'author': 'jeremcc', 'author_id': 1436, 'author_profile': 'https://Stackoverflow.com/users/1436', 'pm_score': 1, 'selected': False, 'text': '<p>Red-Gate <a href="http://www.red-gate.com/products/SQL_Data_Compare/index.htm" rel="nofollow noreferrer">SQL Data Compare</a> will do this. Just create a blank data base with the same schema, and run a compare against the original and the blank database. It will generate scripts to insert all of your test data.</p>\n'}, {'answer_id': 33351, 'author': 'Steven Williams', 'author_id': 3294, 'author_profile': 'https://Stackoverflow.com/users/3294', 'pm_score': 2, 'selected': False, 'text': '<p>If you want a light-weight solution, I would recommend <a href="http://vyaskn.tripod.com/code.htm#inserts" rel="nofollow noreferrer">sp_generate_inserts</a>. It is a store procedure you can create on your DB and pass in a variety of arguments to generate insert statements of all the data in the target table.</p>\n'}, {'answer_id': 303578, 'author': 'Paul Rowland', 'author_id': 6268, 'author_profile': 'https://Stackoverflow.com/users/6268', 'pm_score': 0, 'selected': False, 'text': '<p>This works <a href="http://www.sqlscripter.com/" rel="nofollow noreferrer">http://www.sqlscripter.com/</a></p>\n\n<p>New version of SQL Scripter (V2.1) was released last month.</p>\n'}]
['https://Stackoverflow.com/questions/24243', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/298/']