• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

How to merge databases in MS SQL 2005

I have an old copy of my database that has information that we need i  our new database. Is there a way to restore the old DB into the new DB, leaving the new data and only adding the missing data?
0
daunavan
Asked:
daunavan
1 Solution
 
chapmandewCommented:
No, this functionality does not natively exist in SQL Server.  You'll have to add the logic to do it programatically.
0
 
QuintainTCommented:
Or you can use a tool like AdeptSQL Diff which will help you compare the two databases and automatically create insert statements to insert the old data into the new database.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now