Replicating/Synchronizng multiple tables across diffrent Databases on the same instance
- by Idan
I have few tables that needed to be replicated/synchronized across several databases in our SQL Server 2008 cluster.
I know it's possible to replicate between multiple instances, but I'm looking for replication or synchronization in the same instance between specific tables of databases.
The replicaiton/synchronization should happen every half-hour or so, but I don't mind it happening constantly.
I can't use DROP the target table and INSERT (copy) the source table since there are many constraints.
Reason for this is to not manage in the application layer and write to 2 different databases at the same time.
Example:
DB1 has T1, T2 and T3 - these are constantly being updated by the application, APP1 running on DB1.
DB2 needs to have an updated copy of T1 at all times, also, there is a different application, APP2 runs only on DB2.
Both DB1 and DB2 are located on the same instance, INST1.
Would it be possible to replicate T1, T2 and T3 from DB1 to DB2 ?
Thanks,
Idan.