November 26, 2002 at 7:00 am
Looking for a script(s) that will create a limited set of data from each table and create a sample table on another server.
November 26, 2002 at 1:33 pm
What do you mean? Limited set of data?
It really depends. There are some generators for data, but they tend to be a little pricey and they work for certain scenarios only. If you've got some data, perhaps grab a top xx from the table and insert it in the next table. Hard to do this generally without some DDL.
Steve Jones
November 28, 2002 at 1:03 am
Yes Steve is correct that data generators works for some scenarios.I know a tool called DataFactory but it has a price tag we have found some difficulties while generating data from it.
Regards,
Affan
December 3, 2002 at 10:11 pm
You can simulate this by doing a select top 5 percent * from each table into your "sample" data base. Just be aware it may not be referentially intact if that's a big consideration for you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply