Have a web server in our Lab environment that needs client tools access to our SQL Server.
By Client Tools we mean sqlcmd.exe and bcp.exe access.
Using Web Service we connect to a site and download text and xml data and write the downloaded data into files. And, we now need to use bcp to feed the downloaded data into SQLServer and later using SQLCmd execute some Stored procedures to move data from the staging tables into the destination tables.
Here are the SQL Server utilities we need and the role they play.
sqlcmd allows us to submit sql statements; and bcp allows us to populate and extract data.
Here is Microsoft’s synopsis:
ODBC & Native Client
For a while ODBC was Microsoft mainstay for client connectivity, then came OLE-DB, and now we are back to ODBC.
Read more here:
- Microsoft is Aligning with ODBC for Native Relational Data Access
- Introducing the new Microsoft ODBC Drivers for SQL Server
Here is where to find the drivers for each SQL Server Version:
Command Line Tools
Here are the URLs for the command line tools
Again, simple stuff, but if you have not done it a while, it can make you head swirl.