What are the challenges you face when working across database platforms? Take the survey

Cross DB Table-Mover IDENTITY_INSERT error


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


  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.