Synchronizing Sql Server Database with Pi System Database

Question

Hai,

I'm developing a tool to synchronize SQL Server database with a Pi system (OleDb).Each time there is a change in the Pi System I need to update the values in Sql Server Database and vice-versa.Could you please provide me with the options possible and how it can be done.

Thanks, M.K

Answer 1

Maybe you could use an EventPipe on your data and every time a new or edited event comes in you could push that out to the SQL Server.