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 2008 Forums
 SSIS and Import/Export (2008)
 Replication Role in SSIS

Author  Topic 

boggyboy
Yak Posting Veteran

57 Posts

Posted - 2011-05-16 : 12:57:36
I want to merge two databases (database A and database B) into a new database that matches the schema of database A.

If database A is the "System of Record" - the new database is unchanged. If database B is the SOR, I want fields in the new DB to be updated from database B.

To create the new database should I use replication? Thanks in advance!

Nick W Saban
   

- Advertisement -