How to DROP constraints and CREATE them in a pipeline

Bigiron 110

Hi All,

In my pipeline I have TRUNCATE INSERT logic, but some tables cannot be truncated because they are referenced by a FK. Is there a way before the COPY Activity that I can DROP constraints and after the COPY is done Create them? What activity should I use. Please advice.

Thanks

AnnuKumari-MSFT 32,161 Reputation points Microsoft Employee

2023-07-21T05:37:02.2233333+00:00

Hi @Bigiron ,

Just following up to see if the below answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'
Suba Balaji 11,206 Reputation points

2023-07-26T01:32:18.91+00:00

Hello @Bigiron just checking to see if you have checked the below answer and it was of help. If yes, please accept it, as community with similar question will get benefited too. If you have any further question, please reach out to us. Thanks.
Bigiron 110 Reputation points

2023-07-26T12:18:40.4933333+00:00

@AnnuKumari-MSFT @Subashri Vasdudevan Thanks , I will test this and get back to you.
AnnuKumari-MSFT 32,161 Reputation points Microsoft Employee

2023-08-04T06:59:28.64+00:00

Bigiron ,

Did you get any chance to work on the suggested solution? In case if helped, kindly accept the answer by clicking on Accept answer button.

Accepted answer

Suba Balaji 11,206 Reputation points

2023-07-18T13:21:47.34+00:00

Hi @Bigiron

Thanks for your query and using MS Q&A Platform.

For DDL\DML commands, you can make use of script activity in Azure Data Factory\ Synapse Analytics.

Please refer the below links for more details.

https://techcommunity.microsoft.com/t5/azure-data-factory-blog/execute-sql-statements-using-the-new-script-activity-in-azure/ba-p/3239969

https://www.mssqltips.com/sqlservertip/7427/azure-data-factory-script-activity-deploy-databases/

Video Reference:

https://www.youtube.com/watch?v=CLeVkS3XpMU

Please let us know if that helps.

Thanks.
Please sign in to rate this answer.
Suba Balaji 11,206 Reputation points

2023-07-18T14:40:15.0833333+00:00

Here is a sample screenshot for the same @Bigiron

AnnuKumari-MSFT 32,161 Reputation points Microsoft Employee

2023-07-19T08:23:05.6866667+00:00

Hi Bigiron ,

Just checking in to see if the above answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'
Sign in to comment

Share via

How to DROP constraints and CREATE them in a pipeline

0 additional answers