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 :-)