Options
Cross DB Table-Mover IDENTITY_INSERT error
Sallesg
Posts: 5 New member
Hi,
I have setup 3 Table-Mover rules, on which two of them work perfectly but the last raises the error "IDENTITY_INSERT is set to off". Tables have similar structures.
I've tried several things but it all ends with the same error.
Some information:
- the table is being truncated before;
- setting table with "identity_insert ON" didn't made difference;
- there's no FK related to the table;
Thanks in advance
I have setup 3 Table-Mover rules, on which two of them work perfectly but the last raises the error "IDENTITY_INSERT is set to off". Tables have similar structures.
I've tried several things but it all ends with the same error.
Some information:
- the table is being truncated before;
- setting table with "identity_insert ON" didn't made difference;
- there's no FK related to the table;
Thanks in advance
Tagged:
Answers
Thank you for your forum post.
A support ticket has been generated for you, as I need to collect log files and if possible a copy of the MaskingSet you have generated, that you will not want to upload in this public forum. The support ticket number is #307134.
I will correspond with you via the support ticket.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com