↓ Skip to main content
Technology and Me

Scripting with Sql Server 2005

·63 words·1 min
Sqlserver Tips

Scripting with Sql Server 2005
#

Easiest way to go is to get sqlcmd from here, you’ll have to get :

  • sqlncli.msi : Microsoft SQL Server Native Client
  • SQLServer2005_SQLCMD.msi

There is many good tutorials around but to be quick the standard command line is

sqlcmd -SServer -UUser -PPassword -dDatabase -iMyFile.sql

You can also add -b to error out in case of SQL error.