Case Sensitive Record Insert failed in Sync Local Data cache RRS feed

  • Question

  • I have a table with struture like TableName(Code varchar(2), Desc Varchar(20))

    this has records like

    Code     Desc

    a           small apple

    A          Big Apple

    When trying to sync table using Local data Cache it says

    Synchronizing the database failed with the message:
    'A duplicate value cannot be inserted into a unique index. [ Table name = Table1,Constraint name = PK_Table1 ]'

    What could be the reason As current Server database allows these entries having Case sensitive data.




    Thursday, August 26, 2010 1:34 PM


  • check out the documentation under "Client and Server Database Objects Supported by Sync Framework"

  • Sync Framework supports case-sensitive collations on the server, but it has the following limitations:

    • Primary key columns and columns that have unique indexes or constraints cannot contain values that differ only in case, such as VALUE1 and value1.

    • Synchronizing database objects that differ only in case, such as TABLE1 and table1, is not supported.

Thursday, August 26, 2010 2:05 PM