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.53k stars 896 forks source link

Schema compare cannot exclude message missing name of dependant #8126

Closed kisantia closed 4 years ago

kisantia commented 4 years ago

So far have only noticed it for this case(other excludes show the name of the dependency correctly):

Repro steps:

  1. Compare AdventureWorks with something
  2. Try to exclude a SqlUser like amy0
  3. Fails with this message image

It's failing because of the SqlRole dependency of SalesPersons, but for some reason the name of the object isn't populated when passed back from the GetExcludeDependencies() call to DacFx. image

udeeshagautam commented 4 years ago

We can start by fixing the error message before going to DacFx and fixing that