Microsoft® SQL Server® 2008 R2 Feature Pack

demo

The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2.
Overview

The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2. It includes the latest versions of:

• Redistributable components for Microsoft® SQL Server® 2008 R2.
• Add-on providers for Microsoft® SQL Server® 2008 R2.
  

Note: Some components in the Microsoft® SQL Server® 2008 R2 Feature Pack of SQL Server® have certain Internet-enabled features, including the Customer Experience Improvement Program and Error and Usage Reporting component, enabled by default to help us identify and address issues that you may encounter while using SQL Server®. For more information and instructions on how to disable these features, see the SQL Server® Privacy Statement

Note: Some components in the Microsoft® SQL Server® 2008 R2 Feature Pack of SQL Server® have two different methods to complete the installation process:

• Attended Installation – an interactive user interface will guide you through the set-up process and obtain all of the information and consent required to complete the installation. This includes the displaying, acknowledgement, and archiving of the applicable SQL Server license terms.
  
• Un-attend Installation – this is a DOS command Line set-up process that does not have an interactive user interface to guide you through the set-up process. In this case, you will be required to enter a parameter during installation that indicates your acceptance of the license terms.
  

System requirements

Supported operating systems: Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP

Note: System requirements may vary among the install packages included in the Feature Pack.

Note: When an MSI package is redistributed it must not be renamed, otherwise you may see failures if updates are installed for that package.

Instructions

Download the appropriate file by clicking one of the links below, then run the downloaded file to install that package.

Each item below indicates a short description of the package, and the audience(s) for which it was intended, as follows:

Customer: An individual may want to install this for additional licensed functionality.
Partner: An ISV may want to ship this as a redistributable component as part of their application.
Developer: A programmer may want to install this to support application development.

Note: To archive a copy of the license terms, prior to accepting them, copy and paste the terms to a word processing program, then print or save the file to your favorite directory.

.........................

Microsoft® SQL Server® Compact 3.5 SP2

SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP 2 on Windows desktop.

Audience(s): Customer, Partner, Developer



Download site

Microsoft® SQL Server ®Compact 3.5 SP2 Server Tools

SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP 2 on Windows desktop.

Audience(s): Customer, Partner, Developer



Download site

Microsoft® SQL Server® Compact 3.5 SP2 Books On-line

SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP 2 on Windows desktop.

Audience(s): Customer, Partner, Developer



Download site

Microsoft® SQL Server® 2008 R2 Books On-line

Microsoft SQL Server 2008 R2 Books Online is the primary documentation for SQL Server. Visit the SQL Server 2008 Books Online page on the Microsoft Download Center.

Audience(s): Developer, DBA


Download site

Microsoft® SQL Server® 2008 R2 Upgrade Advisor

Microsoft SQL Server 2008 R2 Upgrade Advisor analyzes instances of SQL Server 2000, SQL Server 2005 and SQL Server 2008 in preparation for upgrading to SQL Server 2008 R2. Upgrade Advisor identifies feature and configuration changes that might affect your upgrade, and it provides links to documentation that describes each identified issue and how to resolve it.



X86 Package (SQLUA.msi)
X64 Package (SQLUA.msi)
IA64 Package (SQLUA.msi)

Microsoft® SQL Server® 2008 R2 Native Client

Microsoft SQL Server 2008 R2 Native Client (SQL Server Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL Server Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2008 R2 features. This redistributable installer for SQL Server Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 R2 features, and optionally installs the header files needed to develop an application that uses the SQL Server Native Client API.

Audience(s): Customer, Partner, Developer



X86 Package (sqlncli.msi)
X64 Package (sqlncli.msi)
IA64 Package (sqlncli.msi)

Microsoft® Core XML Services (MSXML) 6.0 SP 1

Microsoft Core XML Services (MSXML) 6.0 SP 1is the latest version of the native XML processing stack. MSXML 6.0 provides standards-conformant implementations of XML 1.0, XML Schema (XSD) 1.0, XPath 1.0, and XSLT 1.0. In addition, it offers 64-bit support, increased security for working with untrusted XML data, and improved reliability over previous versions of MSXML.

Audience(s): Partner, Developer



Download site

demo

Microsoft® SQL Server® 2008 R2 Shared Management Objects

The SQL Server Management Objects (SMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer SQL Server objects and services. This object model will work with SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.
Note: Microsoft SQL Server 2008 R2 Management Objects Collection requires Microsoft Core XML Services (MSXML) 6.0, Microsoft SQL Server Native Client, and Microsoft SQL Server System CLR Types. These are available on this page.

Audience(s): Customer, Partner, Developer



X86 Package (SharedManagementObjects.msi)
X64 Package (SharedManagementObjects.msi)
IA64 Package (SharedManagementObjects.msi)

Microsoft® SQL Server® 2008 R2 ADOMD.NET

ADOMD.NET is a Microsoft .NET Framework object model that enables software developers to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2008 R2 Analysis Services. ADOMD.NET is a Microsoft ADO.NET provider with enhancements for online analytical processing (OLAP) and data mining.

Note:The English ADOMD.NET setup package installs support for all SQL Server 2008 R2 languages.

Audience(s): Customer, Partner, Developer



X86 Package(SQLSERVER2008_ASADOMD10.msi)
X64 Package (SQLSERVER2008_ASADOMD10.msi)
IA64 Package(SQLSERVER2008_ASADOMD10.msi)

Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2

The Analysis Services OLE DB Provider is a COM component that software developers can use to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2008 R2 Analysis Services. This provider implements both the OLE DB specification and the specification’s extensions for online analytical processing (OLAP) and data mining.

Note: Microsoft SQL Server 2008 R2 Analysis Services OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0, also available on this page.

Audience(s): Customer, Partner, Developer



X86 Package(SQLServer2008_ASOLEDB10.msi)
X64 Package (SQLServer2008_ASOLEDB10.msi)
IA64 Package(SQLServer2008_ASOLEDB10.msi)

Microsoft® SQL Server® 2008 R2 Analysis Management Objects

Analysis Management Objects (AMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer Analysis Services objects.

Audience(s): Customer, Partner, Developer



X86 Package(SQLSERVER2008_ASAMO10.msi)
X64 Package (SQLSERVER2008_ASAMO10.msi)
IA64 Package(SQLSERVER2008_ASAMO10.msi)

Microsoft® SQL Server® 2008 Data Mining Add-ins for Microsoft® Office 2007

Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007 enables you to take advantage of SQL Server 2008 predictive analytics in Office Excel 2007 and Office Visio 2007. The download includes the following components:
• Table Analysis Tools for Excel: This add-in provides easy-to-use tools that leverage SQL Server 2008 data mining features to perform powerful analytics on your spreadsheet data. Two new tools have been added for this release: Prediction Calculator and Shopping Basket Analysis.
• Data Mining Client for Excel: This add-in enables you to go through the full data mining model development lifecycle within Excel 2007 using your spreadsheet data or external data accessible through your SQL Server 2008 Analysis Services instance. This release adds support for new SQL Server 2008 data mining features including holdout and cross-validation, a new Document Model wizard, and improvements to existing wizards.
• Data Mining Templates for Visio: This add-in enables you to render and share your mining models as annotatable Visio 2007 drawings.
  
  
  
Audience(s): Customer, Partner, Developer

Download site

Microsoft® Datamining Viewer Controls For Microsoft® SQL Server® 2008

The Data Mining Web Controls Library is a set of Microsoft Windows Forms controls that enable software developers to display data mining models created using Microsoft SQL Server 2008 Analysis Services in their client-side applications. The controls in this library display the patterns that are contained in Analysis Services mining models.

Audience(s): Customer, Partner, Developer



X86 Package(SQLSERVER2008_ DMViewer.msi)

Microsoft® SQL Server® Driver for PHP 2.0

The Microsoft Drivers for PHP for SQL Server are PHP 5 extensions that allows for the reading and writing of SQL Server data from within PHP scripts. The SQLSRV extension provides a procedural interface while the PDO_SQLSRV extension implements PDO for accessing data in SQL Server. The drivers work with all editions of SQL Server 2005 and later, as well as SQL Azure, and rely on the Microsoft SQL Server Native Client to communicate with SQL Server. The SQL Server Native Client can be downloaded on this Feature Pack page.

Audience(s): Developer



Download Site

Microsoft® SQL Server® Migration Assistant

Microsoft SQL Server Migration Assistant (SSMA) is a family of tools that dramatically cut the effort, cost, and risk of migrating from Oracle, Sybase, MySQL or Access to any edition of SQL Server 2008 R2 or SQL Server 2008 or SQL Server 2005. SSMA for MySQL and SSMA for Access products also support simple and direct migration to SQL Azure. SSMA provides an assessment of migration efforts as well as automates schema and data migration.

Audience(s): Customer, Partner, Developer



1. Microsoft SQL Server Migration Assistant for Access v4.2 - out of the two downloads, ‘SSMA 2008 for Access’ enables migration to SQL Azure
2. Microsoft SQL Server Migration Assistant for MySQL v1.0 - out of the two downloads, ‘SSMA 2008 for MySQL’ enables migration to SQL Azure
3. Microsoft SQL Server Migration Assistant for Oracle v4.2
4. Microsoft SQL Server Migration Assistant for Sybase v4.2
5. Microsoft SQL Server Migration Assistant 2008 for Sybase PowerBuilder Applications v1.0

Microsoft® SQL Server® 2008 R2 Best Practices Analyzer

SQL Server 2008 R2 Best Practices Analyzer is an analysis tool that validates your system configuration and execution against a recommended set of best practices developed by SQL Server Engineering and Customer Support.

Audience(s): Customer, Developer



Download Site