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.57k stars 901 forks source link

Comparison is false... #24754

Open GearTheWorld opened 1 year ago

GearTheWorld commented 1 year ago

Steps to Reproduce:

Start a SHEMA COMPARE between a LOCAL database and a Azure database

The result is false. When we open both files in ADS both are absolutely identical yet from the comparison we see the local not having [dbo].[...] but in fact it have it when we open the stored procedure so again both files are identical but the comparison sees them differently !?

image

Does this issue occur when all extensions are disabled?: Yes/No YES

I clicked the REPORT HERE from the Extension page. Hope it's ok !

SakshiS-harma commented 1 year ago

Do you have an example dacpac that you can share to repro the problem here?

GearTheWorld commented 1 year ago

Do you have an example dacpac that you can share to repro the problem here?

I don't have that. It's a production database which I can't share.

Here's the declaration in the LOCAL stored procedure :

ALTER PROCEDURE [dbo].[spGetInvoiceServiceTypesDescriptions]

I clearly see the [dbo].[...] being there but when I compare, it's not there for the LOCAL stored procedure and it's there in Azure.

GearTheWorld commented 1 year ago

image