DacFx: Schema compare between 2 databases with external tables doesn't work
- Azure Data Studio Version: 1.43
- OS Version: WIndows 11
Steps to Reproduce:
- open schema compare window via project plugin
- select a synapse dedicated pool with external tables as source
- select a 2nd synapse dedicated pool with same external tables as target
- click on compare
actual result: All external tables are mentioned as changed expected result: Only external tables with different DDL/structure are listed
Both external tables have the exact same definitions. The external location bronze_datalake_dfs_core_windows_net is pointing to other physical locations.
Does this issue occur when all extensions are disabled?: N/A
Microsoft schema compare tool (part of DB projects extension
About this issue
- Original URL
- State: closed
- Created a year ago
- Comments: 30 (11 by maintainers)
A new sqlpackage was released today that should have the fix for external tables being dropped and recreated. Can you please try it and see if that is working as expected? After that’s confirmed, I can get the DacFx version used in ADS updated in insiders to a version that includes that fix.