Synchronizing Sql Server database with Pi System (OleDb)

Question

Hai,

      I'm developing an application which needs to synchronize data between Sql Server database and Pi System(Oledb).Can you please provide me the code to doing it.Whenever the data is modified in the SQL db it should get reflected in Pi System and vice versa.How can i achieve this ?

Thanks,

M.K

Answer 1

What database is the PI system using?

---

-- RBarryYoung, [phone] blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Answer 2

not clear on the objective you have, i assume PI never updates data - it stores new data with a new timestamp.  then what will you sync inbound to PI from SQL?