Loading

Monitor database changes and update another

Adam

Hi

I have a situation where we have an application that we have written and a third party application. Basically when a change happens in the 3rd party SQL database, we want to make changes to our own SQL database.

What would be the best way to achieve this? Obviously a combination of SQL triggers/stored procedures could achieve this, but was wondering if there was another alternative?

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sukesh Marla14y ago
Accepted answer
I think best way will be using Triggers, it will a biggest risk trying other solutions becuase you are using 3 rd party application and so unaware about logic they written