Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-19 : 08:39:25
|
| David writes "I am trying to figure out a test strategy that will allow me to build a large dataset to test our ever changing product which runs on SQL server.We are working on Version 1.0 of our product and like any pre version 1.0 product it is going through lots of changes which includes changes to its database structures.I am looking for a tool or procedure that will allow me to build the basic data we will use for testing but also provide me an easy mechanisism to add more data and recover from scheme changes which invalidate some of my tables.I am considering DBUNIT but this is not for UNIT testing I just like that act I can deal with the data in an XML format and that I can grab new snapshots daily and if required manually manipulate the data.Do you have any other suggestions? or best practices?ThanksDave" |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-19 : 09:06:59
|
| U can create some functions to create each type (whatever the data types u have in ur tables) of random dataCall those functions in a stored procedure which generates data, using the above functions, in a loop |
 |
|
|
bakerjon
Posting Yak Master
145 Posts |
|
|
|
|
|
Test Databases