SQLCMD variables for input SQL file

In short, this is an example of how you do it. Set a couple of variables, use -v parameter sqlcmdVariable="%batVariable%". The following contains more details on how to use SQLCMD variables for an input SQL file. Note, I am not advising you to you use this as your routine backup method. If you're looking for…

Batching SQL Scripts to Automate Deployments (with .bat/cmd)

With this technique, you don't have to buy anything or spend time installing fancy stuff. Just write some commands, copy/paste and save as .bat or cmd. [Not discrediting any other implementation, just sharing my experience with a simple method]. When you end up running the batch I recommend doing it on the target server, not your workstation…