Solved

How to merge databases in  MS SQL 2005

Posted on 2009-04-13
2
215 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

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

A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
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 …

688 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