sqlsqlcmd

How to change the port when calling sqlcmd

I have this command

sqlcmd.exe -E -i "C:\joe-db-scripts\joe-db-tasks.Install.sql"

and I need to add the specific non-standard port of 32001. How do I do that? I was thinking of some flag like -p or something but I don't know the syntax.

Solution

  • According to this MSDN link, you'd use -S tcp:servername,32001.