Generating test data -- sql server new users

sql server new users : Generating test data

James
3/24/2005 11:09:23 AM

Are there any good tools in SQL Server 2000 for generating test data to
populate a database? Or do I have to look for third party solutions? Any
suggestions welcome.
Jim

Andrew Watt [MVP - InfoPath]
3/24/2005 5:57:17 PM

On Thu, 24 Mar 2005 11:09:23 -0500, "James" <JJohnson@Adsystech.com>
[quoted text, click to view]

Do the sample databases like AdventureWorks2000, Northwind and pubs
not provide sufficient test data for your needs?

Did you have some specific type of test data in mind?

Andrew Watt

Ryan Schellenberg
3/24/2005 9:22:49 PM

[quoted text, click to view]
If the sample db's don't work for me, I have written up a quick loop in
tsql that will fire 50k rows into a table... for unique id's eiher throw
a counter in, or a time stamp... BOL will help with the syntax...

Daniel Joskovski
3/26/2005 12:57:59 AM

Hi James,

There are some tools
Database Generator and Database Hammer, you can find those tools in SQL
Server 2000 Resource Kit Utilities.

Regards,
Daniel

[quoted text, click to view]

James
3/29/2005 12:37:29 PM

Thanks Daniel for the info.
Jim

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

home · blog · groups

Questions? Comments? Contact the dn