Geek Answers Handbook

SQLCMD variables and SSDT schema comparison problem

I want the comparison below not to show a difference. According to MSDN (see step 7), there must be a SQLCMD Variables function that I cannot find. This documentation is for SQL 2010, but I'm using 2012. There is no version of the documentation available on this page on this page.

How can I specify the value of $(DatabaseName) to make this comparison work? I already have the value specified in the database project settings.

SQL Schema Compare

+8
sql-server compare database-schema database-project ssdt
source share
1 answer

You can get around this by comparing your development database, not your project, with a live database. Keep in mind that you must first deploy the project to your development database.

Fyi. The fact that the variables are not replaced is only a problem in the comparison window. Variables do not cause false differences during the comparison (in other words, Schema Compare replaces the variables when comparing), and the variables are replaced when the target database is updated.

+3
source share

More articles:


All Articles