I am trying to do Test to Live and keep getting the following error
[12:23:52] SyncData - Data Sync - Sync failed:
The DELETE statement conflicted with the REFERENCE constraint "fkey$im_incident$company". The conflict occurred in database "LDSD_TEST", table "dbo.im_incident", column 'im_company_guid'..
I have also used the Test to Live checker tool but I am unable to find the table "dbo.im_incident" in that tool.
I am at a loss to what has caused this error. Any help would be appreciated.
Run the following query on your Test & Live database and then compare the results to find the missing group from the Test system.
from tps_company c
inner join tps_group g on c.tps_guid=g.tps_guid
order by g.tps_name
Retrieving data ...