Share via

AzureSQL PaaS Database and External Data Sources in Visual Studio

grajee 371 Reputation points
2021-03-11T03:36:11.857+00:00

All,

I'm new to Visual Studio. I created the scripts for External Data Sources, database scoped credential and EXTERNAL Tables .

Where should the external data source definition along with the database scoped credential script be placed in the project. If I place them in the pre-deployment script the build is erroring out due to dependency issues.

Thanks,
grajee

Azure SQL Database
Accepted answer
  1. Nandan Hegde 34,436 Reputation points MVP
    2021-03-11T04:47:05.54+00:00

    Hey @grajee ,
    Rather than checking in the External data source as a part of Pre deployment script,
    Create separate SQL files for the external data sources

    76621-ext.png

    76553-blob.png

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.