SQL errors

lfj0503lfj0503 Posts: 2
edited October 14, 2008 5:52AM in SQL Data Compare Previous Versions
The following error message was returned from the SQL Server:

[547] The DELETE statement conflicted with the REFERENCE constraint "TARPAUSCHALE_TARZTRPH_FOREIGN1". The conflict occurred in database "PARK_DB_BRUUNS", table "dbo.TARPAUSCHALE".

The following SQL command caused the error:

DECLARE @pv binary(16)

I get this error when I run the synchronization, but the synchronization has been running in monts witout problems, and then suntenly this error occours.

Can you help me ?

Lars Frost
It-mannager

Comments

  • Try switching on the option 'Ignore Foreign Keys and Check Constraints' - that ought to get you past the immediate problem. It sounds like you have added or enabled a foreign key, or added data to a table in the target which was previously always empty (and hence would never have triggered this problem before).
    Software Developer
    Redgate Software
Sign In or Register to comment.