Skip to content

SQLCMD Create User and Password #490

Open
@dlevy-msft

Description

@dlevy-msft

Imagine a sample that tries to setup a developer’s environment with one, two, or three different containers – only one is SQL. Docker commands are enough, but sqlcmd is easier – or at least could be. To do this, the password to access SQL will be key.

The requirement would simple be:

  1. Allow a known password to be passed in.
  2. Allow a generated password to be extracted. (not in an interactive way, but a programmatic way)

Activity

stuartpa

stuartpa commented on Jan 11, 2024

@stuartpa
Collaborator

We are looking at solving this with add-ons (in the same way Azure Container Apps does), so secret management is completely abstracted away from the user. There is a rough POC of this in #319 that can be used for demo purposes:

e.g the command:

sqlcmd create mssql --use https://github.com/stuartpa/DabBlazorSamplePages.git --add-on dab --open vscode

Sets up an environment (a sqlconfig context) with two containers, one SQL Server container, and one Azure Data Builder container. The password management is done for you by sqlcmd. This command line goes onto clone the sample repo, and loads VS Code, all the user has to do to launch the application is press F5 in VS Code.

To clean up all the containers, the use just does "sqlcmd delete"

e.g. the command:

sqlcmd create mssql --use https://github.com/stuartpa/DabBlazorSamplePages.git --add-on dab --add-on fleet-manager --open vscode

Sets up an environment (a sqlconfig context) for a multi-tenant application, using three containers, one SQL Server container, one Azure Data Builder container and one Azure Database Fleet Manager container. The password management is done for you by sqlcmd.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Relationships

None yet

    Development

    No branches or pull requests

      Participants

      @stuartpa@dlevy-msft

      Issue actions

        SQLCMD Create User and Password · Issue #490 · microsoft/go-sqlcmd