hi , I have database 'center' with huge data and wanted to create a dummy 'test' database for 'center' db with 1000 random data for testing purpose. I generated script to copy the db but the resulting 'test' db was tables without data. i need 1000 samples for all the tables.. please help me.. am using MS SQL 2008 R2. thank you.
Ichcha
0
Light Poster
Recommended Answers
Jump to PostYou have to prepare an insert script of desired number of records from desired tables.
All 2 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.