sqlpackage deployment script is recognized differently due to CR/LF.

[sqlmvp]

• SqlPackage or DacFx Version: SqlPackage 162.5.57.1
• .NET Framework (Windows-only) or .NET Core: .NET Frameworkd and .NET Core
• Environment (local platform and source/target platforms): Windows and Linux(docker)

Steps to Reproduce:
I am developing a deployment pipeline using SqlPackage. The build (creating a Nuget package) is done on a Windows server. The deployment is executed on a Linux container. When I generate a deployment script using the Action:Script command in SqlPackage, it recognizes that the versions are different due to the CR/LF problem, and recognizes it as a new version even though there are no changes.

1. Create Nuget on Windows
   msbuild.exe" "${{ inputs.projectFile }}" /p:Configuration=Release /p:platform="any cpu" /p:OutputPath="${{ env.releasePath }})

2. Create deploy script on Linux (Conteriner)
   sqlpackage /action:script
   /sf: DB.dacpac
   /pr:DB.publish.xml
   /op:output.sql
   /tsn:TARGET_SERVER_DOMAIN
   /tdn:TARGET_DB_NAME
   /tu:TARGET_USER_ID /ttsc:true
   /tp:TARGET_USER_PWD \

Did this occur in prior versions? If not - which version(s) did it work in?

(DacFx/SqlPackage/SSMS/Azure Data Studio)

[SimonSQLML]

I'm coming from the same team with @sqlmvp .

Reading dacpac from windows machine and linux machine are treated differently for CR/LF.
Even though, the target DB have exactly same SP. the SqlPackage publish or script feature does update to all SP to replace CRLF to LF to the target server.
Target servers are windows.

This is a critical bug.

We need a option to ignore similar like IgnoreWhitespace.
In addition, option to enforce use CR/LF only when we run the deployment from linux to windows.

Thanks,

[dzsquared]

Completely agree that there should be an easier way to normalize the line endings in the deployment - I'm curious though why you are building from a windows pipeline?

edit: you mentioned "we need a option to ignore similar like IgnoreWhitespace" - this property defaults to true, but it's missing the CR/LF differences as whitespace (the bug)

[dkultasev]

We have the same problem :(

[narcis-ro]

Same problem.. dacpac and deploy script is created in linux container in github actions. Devs use windows, in compare it shows empty differences on SP