none
Sync Framework - Relational tables

    Question

  • Hi,

    I'm syncing a sql server db called Immo with a sql express db called locImmo. I have a table called Proprietaire  with a FK to a table called TypeCivilite. I add the tables to the scope description in the order: TypeCivilite then Proprietaire. TypeCivilite is syncced but then for table Proprietaire I have the below error:

    The INSERT statement conflicted with the FOREIGN KEY constraint "Proprietaire_TypeCivilite". The conflict occurred in database "locImmo", table "dbo.TypeCivilites", column 'Id'.

    All I read from the internet is to add the tables in the correct order which I did. So I'm stuck with that error and help would be welcome :-)

    Tks.

    François

    Tuesday, August 20, 2013 3:31 PM