Test Data
-
Anyone know how I can script the data that exists in datatables in SQL2k5 into inserts so that they can be bundled as test data with an article?
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook "There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib "Animadvertistine, ubicumque stes, fumum recta in faciem ferri?"
-
Anyone know how I can script the data that exists in datatables in SQL2k5 into inserts so that they can be bundled as test data with an article?
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook "There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib "Animadvertistine, ubicumque stes, fumum recta in faciem ferri?"
I usually write my own. Here is a tool I found that may do the trick for you. http://vyaskn.tripod.com/code.htm#inserts
Cheers, Karl Just a grain of sand on the worlds beaches.
-
Anyone know how I can script the data that exists in datatables in SQL2k5 into inserts so that they can be bundled as test data with an article?
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook "There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib "Animadvertistine, ubicumque stes, fumum recta in faciem ferri?"
Are you using Visual Studio 2008? I have used VS2008 support for "Publishing database to provider" for my articles. It's pretty cool. Here is the section of the article that deals with it: http://www.codeproject.com/KB/aspnet/VS2008MessageBoard1.aspx#AboutInstall[^]
-
Anyone know how I can script the data that exists in datatables in SQL2k5 into inserts so that they can be bundled as test data with an article?
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook "There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib "Animadvertistine, ubicumque stes, fumum recta in faciem ferri?"
Microsoft SQL Server Database Publishing Wizard[^] can script databases to a text file. Rather useful, and can also be run from the command line. ChrisB
-
Anyone know how I can script the data that exists in datatables in SQL2k5 into inserts so that they can be bundled as test data with an article?
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook "There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib "Animadvertistine, ubicumque stes, fumum recta in faciem ferri?"