azuredatastudio: Schema Compare tool showing objects as changed but no differences displayed in the diff itself (potential line ending mismatch)

Azure Data Studio Version:

Version: 1.37.0
Commit: d904740d93d7df76a0ba361f20e4351813b57645
Date: 2022-06-14T00:52:49.854Z
VS Code: 1.59.0
Electron: 13.6.6
Chrome: 91.0.4472.164
Node.js: 14.16.0
V8: 9.1.269.39-electron.0
OS: Linux x64 5.13.4-051304-generic

OS Version:

NAME="Ubuntu"
VERSION="20.04.4 LTS (Focal Fossa)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 20.04.4 LTS"
VERSION_ID="20.04"
KERNEL=5.13.4-051304-generic

Steps to Reproduce:

Right click on a Database Project
Select “Schema Compare” from dropdown menu.
In the open Schema Compare menu select a SQL Database as the source and Database Project as the Target
Observe that views and stored procedures appear with ‘Change’ in the Action column but the ‘Compare Details’ window below shows no material difference.

Could this be a line ending issue where procedures with CRLF line endings in the database compared the LF characters in the sqlproj files?

Does this issue occur when all extensions are disabled?: No - requires Databse Project Extension for Schema Compare

About this issue

Original URL
State: closed
Created 2 years ago
Comments: 16 (7 by maintainers)

Most upvoted comments

Hi @Benjin. Thanks for your efforts on this. I’ve only just had chance to attempt to recreate this from scratch. Following a very similar methodology to what you described above I am also unable to recreate this.

The project I am currently working on was an existing database that I have imported into SSDT but yet to rerun the publish on the production database. Would this have any impact do you think?

Thinking about this, perhaps a more accurate workflow would be:

[SSMS, Windows] Create a SQL Server Database and add a stored procedure to the database against a local SQL Server Instance (this is mimicking our production database we haven’t run publish against yet)
[SSDT, Windows] create new SQL project, and import the database + stored procedure into the SQLproject
[SSDT, Windows] Check the project into git repo
[SSDT, Windows] Publish the project to a SQL Server 2019 Docker container
[ADS, Mac/Linux] Clone the repo
[ADS, Mac/Linux] Use Schema Compare to compare the project with the database running on the Docker container/local SQL Server instance

I’ve dropped you an email as well if you’d like to arrange a call/screen share- I am happy to facilitate.

sgarwood on Oct 19, 2022