Preparing test data with a SETUP script.
So you have a database with real data that you want to use in your testing framework and you are looking for a way to get that data out so that it can be maintained in a script and be run as part of your unit tests.
Thycotic Software has a great tool for generating a setup script for your test data.
"Thycotic.DatabaseScripter is a simple utility that generates a stored procedure called "SETUP" which will remove all data from your database and then reinsert it in the correct order. It uses the system tables in the database to identify foreign key dependencies and make sure data is manipulated in the appropriate manner."