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
Answer accepted by question author
  1. Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator
    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' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.