войти
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Sync Peachtree database without triggers + Local Db has Different Column Names as Remote Database

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

  • 28 декабря 2011 г. 10:27
     
     
    Нужно войти
    0

    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
     

Все ответы

  • 6 января 2012 г. 5:11
    Модератор
     
     
    Нужно войти
    0

    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.