I want to pull Few tables (33 Tables) from one DB server A to another DB server B.
I have Schema ready with few datas in DB Server B but when I try to pull data from DB Server A to DB Server B,
I am getting following error:
The INSERT statement conflicted with the FOREIGN KEY constraint "Table 1".
The conflict occurred in database"DB Server A", table "dbo.Parent Table", column 'xyz'.
The code which I used for this Operation:
INSERT INTO server1table (X,Y,Z) from server2.database.dbo.server2table
So what are the possible ways to do this operation taking care of key constraints?