Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to merge databases in  MS SQL 2005

Posted on 2009-04-13
2
Medium Priority
?
222 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 2000 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

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.

Question has a verified solution.

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

A bad practice commonly found during an account life cycle is to set its password to an initial, insecure password. The Password Reset Tool was developed to make the password reset process easier and more secure.
Transferring FSMO roles is done when an admin wants to split roles between certain Domain Controllers or the Domain Controller holding the Roles has been forcefully demoted using dcpromo / forceremoval
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

810 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