I have a XYZ Database (50 Tables init and lots of data ) on 01 Server
I need to create a XYZ_MOCK Database on same Server 01 with 20 tables of XYZ Similarly with the exact data of XYZ Database....
SO I DID Create XYZ_MOCK database AND 20 TABLES
Now there are 20 tables with lots of lots of Records in XYZ ......
All i want is now I need to move all the records from XYZ DB to XYZ_MOCK. DB (20 Selected Tables)..
Server01-XYZ Database -table abc (20columns and 10,000rows)
Server01 - XYZ_MOCK Database table abc(20 columns and 10,000rows)....
How can i Insert all records for 20 tables so that my Selected tables in Xyz and XYZ_MOCK lokks same
View Complete Post