I would like to generate a diff file based on the database vs DACPAC comparison. Currently what I am doing is extracting DACPAC from the target database and trying to create a diff file based on that (I am not sure if the DACPAC extraction is the needed step). Everything is OK until the moment when I am trying to use the same config I am using for publishing (to make sure that I am generating the script with the same configuration as I am publishing) using the following command:
"C:\Program Files (x86)\Microsoft SQL Server\130\DAC\bin\sqlpackage.exe" /a:Script /sf:F:\tmp\o.dacpac /tf:F:\tmp\n.dacpac /tdn:ScreenerDb /op:F:\tmp\ScreenerDb.sql /p:SqlPublishProfilePath="F:\TMap\Root\Application\Dev\Database\Financials.SQL\Financials.SQL\Publish Configs\Financials.SQL_Dev.publish.xml"
I am getting the following error:
'SqlPublishProfilePath' is not a valid argument for the 'Script' action.
To be fair, I am just trying to achieve following:
- Create a diff file based on the DB DACPAC and the real database using the same configuration as for publishing.
How can I achieve this?