microsoft / microsoft/go-sqlcmd

Register sqlcmd:// URL protocol when installing sqlcmd with package managers (.msi etc.), add --generate-url to `sqlcmd create`

Open
#311 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

ADS enhancement sqlcmd switch
Dominant language
Go
Stars
595
Forks
91
Avg merge
9h 35m
Merged PRs (30d)
1

Description

Once #310 is implemented, sqlcmd users will be able to share T/SQL repro scripts with their SQL Server configuration (version, database(s) etc.) with a single command-line, and have it pop up in Azure Data Studio e.g:

sqlcmd create mssql --using https://aka.ms/AdventureWorksLT.bak --open ads --file https://tiny.url/my-repro.sql

When asking for help on twitter using the #SQLHelp hash tag, or interacting with CSS, it would be convenient to be able to share this repro in a single URL which will run identically on another persons machine (presume the http(s) links are equally accessible). A --generate-url flag would be added to sqlcmd-create (default to true I presume), this generates a web friendly URL and outputs to console at the end of the create, e.g.

sqlcmd://c3FsY21kIGNyZWF0ZSBtc3NxbCAtLXVzaW5nIGh0dHBzOi8vYWthLm1zL0FkdmVudHVyZVdvcmtzTFQuYmFrIC0tb3BlbiBhZHMgLS1maWxlIGh0dHBzOi8vdGlueS51cmwvbXktcmVwcm8uc3Fs

Copying this link, and pasting it into a local machine run window, would re-create the repro environment locally, with the same version of SQL Server (presuming a --tag was included), database restored, and load the .sql script in ADS.

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the implementation planned in #310 and the sqlcmd create entry point, then inspect how .msi and other package-manager installations are defined. Done means installations register sqlcmd:// and sqlcmd create supports --generate-url, producing a URL that recreates the described configuration and opens the specified script in Azure Data Studio.

Written by the indexing model from the issue text.

Assessment

Tech stack
go
Domain
cli, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.