Skip to content

[Bug]: Open .scmp file using database connections does nothing #20432

@justinburnscorpcu

Description

@justinburnscorpcu

Description

I am expecting the ability to load my "Options" selections as well as my "Include" toggles between my Source and Target database connections from a .scmp file.
What is actually happening is that after clicking "Open .scmp file" and choosing my file that I have saved previously via the VS Code extension, nothing happens. I don't see any error messages. The Source and Target fields don't populate, thus the comparison and "Include" selections don't populate. The Options remain unchanged.

Steps to Reproduce

  1. Add connection to two Azure SQL databases, authenticating via "Microsoft Entra ID - Universal with MFA support"
  2. Open Schema Compare tab
  3. Open .scmp file
  4. After opening file, nothing happens. No error message, and no fields or settings are changed. I have tried repeating this after running a comparison first, and still no luck. At some point in the process, I am wanting the ability to load all my "Options" settings as well as my "Include" selections between the Source and Target when working with direct database connections authenticated via Microsoft Entra ID

Affected Area

  • Connection dialog (SQL Server | Azure browse/Fabric browse)
  • Query results panel
  • Query editor
  • Object Explorer
  • Table Designer
  • Schema Compare
  • Schema Designer
  • Local SQL Server Container provisioning
  • SQL database in Fabric provisioning
  • GitHub Copilot integration
  • Query Plan Visualizer
  • Other (please describe below)

If you selected "Other", please describe the affected area

No response

Environment Information

VS Code: 1.105.1
Extension SQL Server (mssql): 1.36.0
OS: Windows_NT x64 10.0.22621
Connection Type: Microsoft SQL Azure (Authenticated with Microsoft Entra ID)

Confirmation

  • I have searched existing issues and couldn't find a match
  • I want to work on this issue

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions