I have two sites that sell the same product (the same database structure and everything). One of them has recently updated all its products and we have to take data from the three tables on the updated site and override those three tables on the date-site. Is there a way to do SQL Server MS? Tried trying to break tables in Iv sql, then include "Choose from db1table to db2table *" but I only get errors from foreign keys. Someone showed me a trick in the Visual Studio enterprise for a while to compare the data, where vs one. Exclude SQL files that you can run to update your table but I only have professional versus 2010 and it is not part of the package. Suppose that both of your databases have the same foreign key constraints and if the foreign key is the only issue of constraints
why not just you
1) Disable all foreign keys
2) Load the data
3) Enable all foreign keys
I come from the background of Oracle, one in SQL Server Using a script in the bar to disable / enable all foreign key constraints It should not be very difficult. / P>
Comments
Post a Comment