ADF, Pipeline, Copy Activity

Question

All,

I have to copy lot of tables from On-Prem to AzureSQL. I setup a pipeline and copy activities to accomplish the copy. How do I disable IDENTITY insert off to ensure that the identity column values are brought over from the source as they are instead of it getting generated and assigned new values.

Is there an option in the copy activity or the pipeline?

Thanks,
grajee

Answer 1

Hi @grajee

If you don't mind me asking, if you want to copy the Ids you currently have on your On-Prem source, why do you create the identity column in AzureSQL?

Anyway, if you do want to keep that column has an Identity column, you can achieve that in the Copy Activity by executing a pre-copy script on the Sink which disables the identity column before the insert

Answer 2

Hey @grajee ,
When you map the identity columns across source and sink in copy activity, it should copy the data as is automatically without you turning off the identity property manually.