Qlik Replicate: MSSQL insert into Identity columns

[shashi_holla]

Some tables being replicated from Oracle to MSSQL must be inserted into MSSQL tables that contain an Identity column. The Identity cannot be restarted, it must be the same value as on the source. Microsoft has a method in their tools, using the command 'SET IDENTITY_INSERT = ON'.  How can this be achieved using Qlik Replicate? 

Resolution

Set the afterConnectScript internal parameter with the value SET IDENTITY_INSERT = ON on the target MSSQL endpoint. This will execute as soon as the task connects to the DB and ensures the Identity columns are inserted.

1. Go to the  MSSQL Endpoint connection
2. Switch to the Advanced tab
3. Click Internal Parameters
4. Set
   
   Parameter: afterConnectScript
   Value: SET IDENTITY_INSERT = ON
   
   
   
   For more information about Internal Parameter, see Qlik Replicate: How to set Internal Parameters and what are they for?

Environment

Qlik Replicate