Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I apply a rule to synchronize the data between tables in different databases?

April 26, 2017Data databases different rule synchronize tables

0

0 Posted

Can I apply a rule to synchronize the data between tables in different databases?

1 Answer

0

0 Posted

Yes, as long as the database is in the same SQL Server instance and the Rule Controller login has the access rights to update the target table. This is just a variation on a standard Table-To-Table Synchronization rule.