Solved

How to merge databases in  MS SQL 2005

Posted on 2009-04-13
2
208 Views
Last Modified: 2012-05-06
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
Comment
Question by:daunavan
2 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 24129860
No, this functionality does not natively exist in SQL Server.  You'll have to add the logic to do it programatically.
0
 
LVL 5

Accepted Solution

by:
QuintainT earned 500 total points
ID: 24130417
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

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question