로그인
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Sync Peachtree database without triggers + Local Db has Different Column Names as Remote Database

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

  • 2011년 12월 28일 수요일 오전 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
     

모든 응답

  • 2012년 1월 6일 금요일 오전 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.