When deploying sql code artifacts we can use the SQLCMD.exe (and Here for SQL 2008) utility to execute the sql scripts.
one tweak to be aware of is when using the utility to deploy scripts on a remote SQL machine, you need to specify the file path before you specify the server IP.
So, the following example will work for remote SQL deployment: “sqlcmd -E -i <path to the .sql file> -S <Remote Server IP>”
good luck
Uri
I really enjoyed reading your article, keep on posting such exciting articles!
Great idea, thanks for this tip!
It does not work for me:(
Hi
are you getting any error messages?
Make sure that the user running “SQLCMD” has permissions on the remote server.
Uri