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

source share