DML Operations in AzureSQL PaaS on External Databases

Question

grajee 371

All,

We are migrating our database from SQLServer 2012 to AzureSQL PaaS DB. In lot of stored procedures, we have code as below:

USE ClaimDB1
GO

Delete ClaimDB2.dbo.Claims
Where Claimdate < ‘12/01/2020’

Given that DML operations are not allowed on EXTERNAL TABLEs, what are the various patterns of accomplishing the same in the AzureSQL PaaS world?

Thanks,
grajee

Anurag Sharma 17,631 Reputation points

2020-12-22T04:02:07.98+00:00

@grajee , could you please refer to answer provided by @Vaibhav Chaudhari for using the stored procedure to achieve your requirement. If that helps, please accept it as answer or else let us know if you need any more help.

1 answer

Anurag Sharma 17,631 Reputation points

2020-12-22T04:02:07.98+00:00

@grajee , could you please refer to answer provided by @Vaibhav Chaudhari for using the stored procedure to achieve your requirement. If that helps, please accept it as answer or else let us know if you need any more help.

Answer 1

Vaibhav Chaudhari 38,916 Volunteer Moderator

Please see if you can make use of sp_execute_remote SP - solution given in similar thread

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav