sqlcmd.exe and MsBuild

Posted on by

Today I wrote my first MsBuild script that uses sqlcmd.exe to execute SQL Server commands remotely. It is awesome. Although it is fairly limited, for tasks like backing up databases, it is very simple and easy.

  <Target Name="Backup">
	<Exec Command='sqlcmd -S $(server) -q "$(sql)"' />
  </Target>

One thought on “sqlcmd.exe and MsBuild”