Monday, June 9, 2014

Install SQLCMD/BCP and ODBC 11 drivers


1.SQLCMD
Microsoft Command Line Utilities 11 for SQL Server:
    The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server instances
http://www.microsoft.com/en-us/download/details.aspx?id=36433

1.Down load the "c" from above link
2.Run below to install or save in text as install.bat.Then double click on install.bat.
msiexec /quiet /passive /qn /i msodbcsql.msi IACCEPTMSODBCSQLLICENSETERMS=YES ADDLOCAL=ALL /log C:\testlogs.txt
3.Installation complete.

2.ODBC install:http://www.microsoft.com/en-us/download/details.aspx?id=36434
1.Download the "msodbcsql.msi" file from above
2.Run below to install or save in text as install.bat.Then double click on install.bat.
msiexec /quiet /passive /qn /i msodbcsql.msi IACCEPTMSSQLCMDLNUTILSLICENSETERMS=YES /log C:\testlogs.txt





No comments:

Post a Comment