microsoft / microsoft/DacFx

Support the parameterization of the schema name in a SQL Server project

Open
#569 0 comments 1 reaction 0 assignees View on GitHub
enhancement
Dominant language
C#
Stars
460
Forks
29
Avg merge
4d 9h
Merged PRs (30d)
7

Description

Incoming from https://developercommunity.visualstudio.com/t/Support-the-parameterization-of-the-sche/10824776

> As I understand it, VS supports the parameterization of the database name in a SQL Server Database Project but not the schema name. The additional of this feature / capability would be particularly useful in the follow use-case that I am trying to support - namely the use of a single database with “business project” specific schemas. i.e the solution I am working with supports separate data repositories for each “business project”. The name of the schema that would be created for a specific “business project” will not be known until deployment time and is determined by the business. I can easily support this using sql scripts where the schema name is defined as a SQLCMD variable - but this doesn’t appear to be supported in VS.

Contributor guide

Open the contributing guide

Research direction

No files, tests, or entry points are named. Start by investigating how SQL Server projects currently parameterize database names and SQLCMD variables, then define completion as allowing a schema name to be supplied at deployment time.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.