Dynamically Manage Values for External Data Source in db projects

[Abhinav530]

I have a db project (Visual Studio) solution for my azure SQL Datawarehouse.

How to dynamically manage the environment specific values(location,credential) for External Data Source so that it gets created with correct values in each environment.

Right now(below is the script) the script is hard coded to dev details, i can not deploy this to STG with dev details,i need to handle this dynamically per environment.

CREATE EXTERNAL DATA SOURCE [Denials]
WITH (
TYPE = HADOOP,
LOCATION = N'wasbs://denials@devsqldwhstorage.blob.core.windows.net',
CREDENTIAL = [dev_credential]
);


Please help me in achieving this.

Thanks

Continue reading...