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

Cross DB Table-Mover IDENTITY_INSERT error

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

Answers

  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    Hi,
    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


    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.