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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy