By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,022 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,022 IT Pros & Developers. It's quick & easy.

Merge data in SQL Server databases

P: 2
I have two databases with identical tables structures. I need to merge the data in both databases without implementing merge replication. Can someone tell me what script to run that will compare the data in those tables? First I know the script has to search for data that doesn't exist in one table, the copy that over from the table that has extra rows. Thanks

Mar 27 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,017
Not sure how to help you unless you want to write a stored proc to do it.
Mar 27 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.