Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Combine 2 databases

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-03 : 07:55:45
Scott writes "I have 2 databases that are the same 1 version before a system crash and one version after. I would like to combine the 2 databases into 1 but do it without any duplicate records. This way I am certain that the users have access to their complete history of data. I am a SQL newbie so please any help you provide if you can spell it out for me that would be GREAT.

Thank you for any help you can provide."

macka
Posting Yak Master

162 Posts

Posted - 2003-07-03 : 09:02:32
Red Gate ([url]http://www.red-gate.com[/url]) offer a tool called SQL Data Compare. I think this should meet your needs - subject to your budget.

[url]http://www.red-gate.com/SQL_Data_Compare.htm[/url]

macka.

--
There are only 10 types of people in the world - Those who understand binary, and those who don't.
Go to Top of Page
   

- Advertisement -