Sqlpackage.exe passes SQLCMD variable when retrieving DACPAC

I use the SQLCMD variable when deploying dacpac when publishing the database, is there any way to use it when I retrieve dacpac from the database. I am comparing the original dacpac that had the SQLCMD variable and extracted from a database that shows the differences as follows

The actual dacpac is as follows

SELECT * FROM $VariableName.tablename

Extracted dacpac gives the following

SELECT * FROM TestVariable.tablename

So, is there any way to exclude this or any alternative way of comparing and matching the result

enter image description here

0
source share

Source: https://habr.com/ru/post/982699/


All Articles