Problems by synchronisation to azure

Question

Hi,

while the synchronisation between our mssql servers errors shown like the picture. I know what this means but how can i find the corrupt record ?

Thanks for help.

Mike

Answer 1

Something like this:

SELECT *
FROM   source a
WHERE s.Messbereich IS NOT NULL  
  AND  NOT EXISTS (SELECT *
                   FROM  Messbereiche M
                   WHERE s.Messbereich = M.Messbereich)

You would need to get the data into some temp table table, so that you can run the query.

Answer 2

Hi @Milan ,

The error message is related to Foreign Key, suggest you try the suggestion from below blog.

Troubleshooting SQL: Agent job failed with Error 547 and Error 3621.

Best regards,
Cathy

---

If the response is helpful, please click "Accept Answer" and upvote it.