Connecting to Pre-Release Versions of SQL Server 2008 – Part Deux

Since posting on the topic of design-time and runtime connectivity to pre-release versions of SQL Server 2008 on the Data blog in November, the set of affected clients (applications, runtimes, and operating systems) have been officially released: Microsoft Visual Studio 2008, Microsoft .NET Framework v3.5, Microsoft Vista Service Pack 1, and Microsoft Windows 2008. Runtime connectivity from a client system configured with any of these released products to SQL Server 2008 November CTP or later provides full runtime access to the following features (for design-time functionality, see below):

· Table-Valued Parameters

· New date/time data types

· Large user-defined types

· Support for very large FILESTREAM-attributed column data

Design-Time Connectivity Between Visual Studio and SQL Server 2008

Developers using Visual Studio 2005 or Visual Studio 2008 design tools will receive an error when trying to open a database on any pre-release instance of SQL Server 2008 without installing a Visual Studio patch. Pre-release patches for Visual Studio 2008 and Visual Studio 2005 enable the following Visual Studio functionality for SQL Server 2008:

· Server Explorer successfully connects to SQL Server 2008, and database objects such as stored procedures and table data can be viewed and edited.

o Note that table schemas still cannot be viewed or edited in this release.

· SQL CLR projects that target SQL Server 2008 can be created and deployed to the server.

· T-SQL and SQL CLR debugging are now enabled for SQL Server 2008.

· Data binding features in Client and Web Projects are enabled.

Pre-release versions of the design-time patches are currently available: the Visual Studio 2008 CTP patch is available for download here and the Visual Studio 2005 CTP patch is available for download here. Final versions of the patches will be available in the near future. For more information please see the "Connecting to Microsoft SQL Server 2008 from Microsoft Visual Studio 2005 and 2008" whitepaper on MSDN.


Debra Dove

Program Manager Lead, Data Programmability