Copy database from one database to another with minimum data

Posted by Kirthiga under Sql Server on 5/3/2013 | Points: 10 | Views : 980 | Status : [Member] | Replies : 1
Im having a database with 500 GB. I have to create a sample database from my original database with the size of 10 GB. In my sample database i need sample of 1000 records from each table from the original database since original database having lakhs of records. Original database tables have constraints and Index i want the same in my sample database tables.

How to create a sample database?


Posted by: Santhi on: 5/3/2013 [Member] Starter | Points: 25


Refer this link:
This may help you.

Thanks & Regards,
Santhi .V

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response