search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.54k stars 897 forks source link

Unable to open .scmp file in Schema Compare #25099

Open kevcrooks opened 9 months ago

kevcrooks commented 9 months ago

Type: Bug

  1. Open a Schema Compare
  2. In Options, change DropRoleMembersNotInSource to false
  3. Save the .scmp file
  4. Confirm the file is showing: 
      <PropertyElementName>
    <Name>DropRoleMembersNotInSource</Name>
    <Value>False</Value>
  </PropertyElementName>
  5. Restart Azure Data Studio and open a new schema compare
  6. Click to Open this .scmp file
  7. Check the Options, and DropRoleMembersNotInSource is still true, so the .scmp file has not been correctly loaded.

Extension version: 1.21.0 Azure Data Studio version: azuredatastudio 1.47.0 (c7c2b2f21505562d21972d4c135119d00806db4f, 2023-11-07T17:17:45.669Z) OS version: Windows_NT x64 10.0.22631 Restricted Mode: No Preview Features: Enabled Modes:

System Info |Item|Value| |---|---| |CPUs|Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz (16 x 2793)| |GPU Status|2d_canvas: unavailable_software
canvas_oop_rasterization: disabled_off
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: disabled_software
multiple_raster_threads: enabled_on
opengl: disabled_off
rasterization: disabled_software
raw_draw: disabled_off_ok
video_decode: disabled_software
video_encode: disabled_software
vulkan: disabled_off
webgl: unavailable_software
webgl2: unavailable_software
webgpu: unavailable_software| |Load (avg)|undefined| |Memory (System)|63.95GB (51.20GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
c624ad2 commented 7 months ago

We are experiencing the same problem with Schema Compare. We have tried opening the .scmp file from the explorer (ref: issue #15880) and using the Open .scmp file button, but still the schema comparison remains blank. We've also checked that the contents of the .scmp-file is correct.

Any possibility that this weill be resolved soon?

Extension version: v1.21.0 Azure Data Studio version: 1.47.1 OS: Windows

Tara-Morovatdar commented 5 months ago

We are experiencing the same problem with Schema Compare. We have tried opening the .scmp file from the explorer (ref: issue #15880) and using the Open .scmp file button, but still the schema comparison remains blank. We've also checked that the contents of the .scmp-file is correct.

Any possibility that this weill be resolved soon?

Extension version: v1.21.0 Azure Data Studio version: 1.47.1 OS: Windows

Did you find any solution? BEcause I am still facing the same issue

c624ad2 commented 5 months ago

Did you find any solution? BEcause I am still facing the same issue

No, we are also still having this issue.

kevcrooks commented 5 months ago

This is still broken for us too.

Unfortunately the only workaround is to manually check/edit all the settings we need for the Schema Compare every time we run it, because we can't trust which (if any) settings have been correctly loaded from the file.

TomaszKarwala commented 3 months ago

I also have the same issue. I can't open .scmp file in Schema Comparer.

image

kevcrooks commented 1 month ago

@corivera I'm still seeing this issue on the latest version. Can you confirm if you need any more information to reproduce?