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:
- Visual studio the project needs to be deployed before it can be started
- Problem with C# using System.Runtime.InteropServices
- Upgrade from Visual Studio 2015 to Visual Studio 2022: Error LNK1104 cannot open file 'msvcprtd.lib'
- What does the Target Platform Version mean for a VS C++ project?
- Where to find "Enable Debugging of Unmanaged Code" to be able to edit the code while the system is running?
- Publish to IIS, setting Environment Variable
- Child node "2" exited prematurely
- Collapse all #regions only(!) in C# (Visual Studio)
- How to ensure that the /EDITANDCONTINUE directive is not ignored
- Stop default Autocomplete behavior when hitting spacebar
- Why does intellisense and code suggestion stop working when Visual Studio is open?
- Strange Build error after upgrading to Visual studio 2015 wants to copy pagefile.sys
- LNK2019 unresolved external symbol _CrtDbgReport referenced in function _CRT_RTC_INIT SDL2
- Missing Microsoft RDLC Report Designer in Visual Studio
- Is there a way to force the Visual Studio document tabs to a specific width?
- Visual Studio Expand Method and All Child Scopes or Collapse Method Only?
- Namespace or type specified in the project-level Imports 'System.Threading.Tasks' doesn't contain any public member or cannot be found
- How can I restart IIS Express within Visual Studio?
- tsconfig.json: Build:No inputs were found in config file
- GLAD failing to initialize
- "Source" VsDevCmd.bat from Cygwin
- VS2015: Quick way to switch from diff to original file
- How to install Visual C++ Build tools?
- How can I use the Visual Studio C/C++ Compiler (cl.exe) to pre-process my objective-C code?
- Can I recover deleted code from a file in Visual Studio 2015?
- TFS - An item with the same key has already been added
- Visual Studio 2015 Ctrl + D (code duplication) not working (keyboard shortcut scheme issue with Resharper)
- Replace 'BackgroundWorker' With 'Thread '
- Visual Basic Random Number Guessing Game
- Ignoring changes to App.config working with git and visual studio