Tuesday, January 15, 2013

SQL Server ODBC Driver 11 and Command Line Utilities 11 for released

Microsoft Downloads - Microsoft® ODBC Driver 11 for SQL Server® - Windows

The Microsoft ODBC Driver For SQL Server provides native connectivity from Windows to Microsoft SQL Server.

Version:11.0.2270.0
Date published: 1/14/2013

1033\x64\msodbcsql.msi, 4.4 MB

1033\x86\msodbcsql.msi, 2.8 MB

Microsoft ODBC Driver 11 for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to Microsoft SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. Microsoft ODBC Driver 11 for SQL Server should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2012 features [GD:Emphasis added]. This redistributable installer for Microsoft ODBC Driver 11 for SQL Server installs the client components needed during run time to take advantage of new SQL Server 2012 features, and optionally installs the header files needed to develop an application that uses the ODBC API.

..."

Microsoft Downloads - Microsoft® Command Line Utilities 11 for SQL Server®

Version: 11.0.2270.0
Date published: 1/14/2013

The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server 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.

You all know that SQL Server support for OLE DB is End of Life'ing, right? Microsoft is Aligning with ODBC for Native Relational Data Access? Any while we don't need to get all crazy today, these updated drivers/redist might come in handy in the coming months/years.

And having the command line tools in their only MSI is also really handy....

 

Related Past Post XRef:
ODBC gets some love in Windows 8 & Windows Server 8 (Improved UI and PowerShell support)

No comments: