microsoft / microsoft/DacFx

SqlCMD variables are not handled by schema compare APIs

Open
#697 6 comments 3 reactions 0 assignees View on GitHub
area: schema compare
Dominant language
C#
Stars
460
Forks
29
Avg merge
4d 9h
Merged PRs (30d)
7

Description

Type: Bug

1. Compare dacpac with database.
2. It fails because sqlcmd variables are not correctly translated.
There differences because [$(DB1)] is not Database1. [$(DB1)] has default value "Database1".

Extension version: 1.20.0
Azure Data Studio version: azuredatastudio 1.45.1 (88c21b1725a3e79440027bdb7b5a55fb036be0e2, 2023-08-03T00:42:37.945Z)
OS version: Windows_NT x64 10.0.20348
Restricted Mode: No
Preview Features: Disabled
Modes:

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the schema comparison described: compare a dacpac with a database that uses the SqlCMD variable $(DB1), whose default value is "Database1". Trace the schema compare APIs to find where the variable remains unresolved, and consider the issue done when the comparison translates it correctly without reporting a false difference.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql
Domain
api, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.