Visual Studio Professional 2015 - SQL Schema Compare & reopening .publish.sql generated scripts
Not sure if this has been an issue before or this is a new error with the latest tools update, however:
I've noticed that after running a comparison between two database and clicking on the "Generate Script" that the *.publish.sql will run perfectly.
However, after saving that file, closing it and re-opening, the
:setvar
blocks are all coming back as incorrect syntax.
Is this a bug in VS or am I doing something wrong?
Solution
You must switch to SQLCMD mode.
--- In Visual Studio 2015:
- How to make local nuget packages and reference them across solutions locally in dotnet core
- Visual Studio 2015 generate UML from code
- Cannot find corecrt.h: $(UniversalCRT_IncludePath) is wrong
- How can I set the 'copy to output directory' property in my nuspec file?
- Find and remove duplicate entries in csproj file
- Disable "You should only open projects from a trustworthy source" message in VS 2015
- How to switch between target frameworks for .NET Core projects in Visual Studio
- $ReturnValue in Watch window doesn't work in VS2015
- SAP Crystal Reports & VS 2015
- Why does intellisense and code suggestion stop working when Visual Studio is open?
- How to run Roslyn instead csc.exe from command line?
- Unable to start debugging. The startup project could not be launched. VS2015
- Visual Studio Shows code errors that don't exist
- Running two projects at once in Visual Studio
- Severity Code Description Project File Line Suppression State Error (downloading from Nuget for Xamarin)
- Upgrade from VS2015 to VS2022: Error LNK1104 cannot open file 'msvcprtd.lib'
- Can't Add View from Controller in VS 2015 : "There was an error running the selected code generator"
- VC compiler (Visual Studio 2015) can not link big (>2G) static lib file
- The default XML namespace of the project must be the MSBuild XML namespace
- A reference to 'YourProject' could not be added. An assembly must have a 'dll' or 'exe' extension in order to be referenced
- How do I save my file in UTF-16 LE encoding without BOM in VS2015?
- Visual studio the project needs to be deployed before it can be started
- Value must match the regular expression ^[^A-Z]+$ - Visual Studio 2015
- Issues using DataTestMethod and DataRow attributes in MS Test
- ASP.NET Core : package.json is missing
- Unrecoverable build error - whilst trying to build setup on VS2015
- A copy of a.cpp was found in somepath, but the current source code is different from the version built into somepath
- SQL46010 Syntax Error when creating a stored procedure in Visual Studio 15
- What is the difference between Publish methods provided in the Visual Studio?
- Nuget error "Object reference not set to an instance of an object" while installing Entityframework 7 from Package Manager Console in VS2015