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… Continue reading SQLCMD variables for input SQL file
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… Continue reading Batching SQL Scripts to Automate Deployments (with .bat/cmd)
You must be logged in to post a comment.