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?