Tuesday, July 03, 2012

Microsoft SQL Server Command Line Tool SQLCMD

SQL Server Command Line Tool SQLCMD can be download from here:
http://www.microsoft.com/en-us/download/confirmation.aspx?id=16978

1. In the above website, search for "Native Client" --> Microsoft® SQL Server® 2008 R2 Native Client

2. In the above website, search for "sqlcmd" --> Microsoft® SQL Server® 2008 R2 Command Line Utilities

The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server 7.0, SQL Server 2000, SQL Server 2005, and SQL Server 2008 and 2008 R2 instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server 2008 R2 and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.
Note: This component requires both Windows Installer 4.5 and Microsoft SQL Server Native Client

Install items 1 and 2.

SQLCMD.exe can be found here: C:/Program Files/Microsoft SQL Server/100/Tools/Binn/SQLCMD.EXE