By Justin Dearing


2019-04-12 11:45:57 8 Comments

I have a SSDT project that deploys to Azure SQL DB. Recently I added an external table. This required an external data source as follows:

CREATE EXTERNAL DATA SOURCE [data_warehouse]
    WITH (
    TYPE = RDBMS,
    LOCATION = N'mydb.database.windows.net',
    DATABASE_NAME = N'MainDW',
    CREDENTIAL = [dw_reader]
    );

When I import this into my .sqlproj, it complains the credential isn't there, and then when I add that it complains the master key isn't there. The problems is I don't want to store those secrets in the SSDT project. How do I store dummys, or defaults that can be overridden and retrieved from the azure keyvault or other method of storing secrets in Azure Decops?

0 comments

Related Questions

Sponsored Content

1 Answered Questions

How to avoid dropping schemas when publishing DB in SSDT Database project

1 Answered Questions

0 Answered Questions

1 Answered Questions

0 Answered Questions

How Can I Ignore Partition Schemes in my VS SSDT Database Project

1 Answered Questions

[SOLVED] Registering a SSDT database project as a data tier application fails

  • 2013-04-25 10:06:25
  • Steve
  • 1204 View
  • 3 Score
  • 1 Answer
  • Tags:   sql-server ssdt

1 Answered Questions

[SOLVED] How to re-include excluded folder in SSDT-BI / Visual Studio 2013 database project?

  • 2015-11-15 22:42:35
  • Tomasz Wieczorkowski
  • 874 View
  • 1 Score
  • 1 Answer
  • Tags:   sql-server ssdt

1 Answered Questions

[SOLVED] Specify windows account for SSRS data source in SSDT project

  • 2015-10-16 11:26:05
  • paulH
  • 487 View
  • 0 Score
  • 1 Answer
  • Tags:   ssrs ssdt

1 Answered Questions

[SOLVED] SSDT: Create User in a database not being part of the project

1 Answered Questions

[SOLVED] In a SSDT project how to avoid redeploying the assembly?

  • 2014-11-18 21:14:13
  • Michael B
  • 1174 View
  • 3 Score
  • 1 Answer
  • Tags:   sql-clr ssdt

Sponsored Content