Sync Peachtree database without triggers + Local Db has Different Column Names as Remote Database

Question

Hello,

I have to bi-directionally Sync SQL Compact with Peachtree.

1. Is it possible to write a Custom Sync Provider for Peachtree which does not support triggers or a mechanism to know when a record is updated, added or deleted?
2. Could I have different Sync column names/Tables for SQL Compact and Peachtree databases? For example Cust.CustName in SQL Compact is required to be in Sync with Customer.FullName of Peachtree database?

Thanks.

Rafey

 

 

 

---

Regards, Rafey

Answer 1

1 - so how would you know which rows to sync if you have no way of tracking what has been added, updated or deleted?

2 - this is possible, you can manipulate the change dataset in the ChangesSelected event to change the columns names.