Microsoft Download Center Archive
![]() | Microsoft® SQL Server® 2012 SP1 Feature Pack |
The Microsoft® SQL Server® 2012 SP1 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2012 SP1.
- The Microsoft® SQL Server® 2012 SP1 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2012 SP1. It includes the latest versions of:
- Tool and components for Microsoft® SQL Server® 2012 SP1.
- Add-on providers for Microsoft® SQL Server® 2012 SP1.
Files
![]() | Status: DeletedThis download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to August 2020. |
File | Size |
---|---|
![]() SHA1: 32b1a4be6117bda3c759fb24a27807a6ffdea0ce | 20 KB |
![]() SHA1: 965ee5572d02d7ee459156a1e22e47531e5d5af6 | 1.09 MB |
![]() SHA1: 56a379a5da9899631d88e37fff9e15a0e76ce2f1 | 1.15 MB |
![]() SHA1: 14e10fa78c602b4edbe235214edda4025e76e858 | 2.70 MB |
![]() SHA1: 4e9d84b5721c28f48e78c0fabf1c580ce2ae7d8a | 2.61 MB |
![]() SHA1: a03e886659b2f0459f6a68b064ea57937c21f618 | 923 KB |
![]() SHA1: 1da94f4188ee4eb66d48503eacf3ff0e29ca05d8 | 2.18 MB |
![]() SHA1: d150ce37f74adf2e8e67a1d3dffbc48f6eb7e011 | 5.92 MB |
![]() SHA1: f7313e6b1f824679ec3f6c9e49f8e2ca6f304e34 | 1.27 MB |
![]() SHA1: 406208628306ace275ed84ae0fe018dbf80fe51b | 1.37 MB |
![]() SHA1: d5cebb7a5227f581fd608fba0fe27a03ec3cec0e | 25.13 MB |
![]() SHA1: 7b44823596204991a6c429486ac47d4897762805 | 3.71 MB |
![]() SHA1: 7e146c0f57292bbe4c2dfb292225f17ccb67300f | 1.36 MB |
![]() SHA1: da3528cc7bc4657292fe4fad8ee497c8eec93679 | 11.19 MB |
![]() SHA1: 43c280495856fed6685cb6ec41c42a3424df14a9 | 4.54 MB |
![]() SHA1: 3edb704d6946ed68ca76db0c73a820394441ffa4 | 2.18 MB |
![]() SHA1: d6fd8077b85c08704e0133ceddb16d5ba826c0d9 | 13.83 MB |
![]() SHA1: 83d293f076254a277a84106c4c5fa77444eabcff | 57.87 MB |
![]() SHA1: d6933fd7961f8486465239e75d08a96df7c78c12 | 1.16 MB |
![]() SHA1: 723269efad697958ce5a5062671aff31ca0275ba | 1.80 MB |
![]() SHA1: b12931e759e4742f80fe3c16e170448e9fc10469 | 1.02 MB |
![]() SHA1: e8a45f64ecaecabc9a7dd33f988bdd9775d1a6b0 | 1.07 MB |
![]() SHA1: 1f5f333a4fd780ed0fd67d48c28b2beb92184ffc | 2.66 MB |
![]() SHA1: 18f1d0daeb157fbc30864ff63ff5e0f9882f28df | 1.61 MB |
![]() SHA1: ebcaf2db481c6f1cb247e6e97982dac33670f9ac | 853 KB |
![]() SHA1: 46d63b78e7a50aca26e68f4a3f0154d32999ebb5 | 1.98 MB |
![]() SHA1: 43571408a5d4f0e9795380dc9c3fdf3900169efe | 5.09 MB |
![]() SHA1: 67c5870fe848128c4cad48e289961b3d4063807c | 1.15 MB |
![]() SHA1: 0aa3f99893126428b5b9cdc22596e27dffd56542 | 1.33 MB |
![]() SHA1: 135acabb14b7aff89ade938ce4f6695b2c8c0cf5 | 11.58 MB |
![]() SHA1: 7e8ec83e2c79299421066a06c688bb60cb384bc3 | 2.05 MB |
![]() SHA1: 775b3a0207fa4f150ba7a584b0a615170451d1ec | 1.19 MB |
![]() SHA1: e43befe253e1ce3c421915073da6685efa1b62cd | 7.42 MB |
![]() SHA1: 19fe54c601a0dc987d59fc31a0431a955ae17c15 | 2.03 MB |
![]() SHA1: 300d2b5a7206fb4c7d210a0be189a90b52dddbaf | 1.58 MB |
![]() SHA1: 89ec3ca4fa1593b369ff3ea3f7a9d1d21926754c | 13.73 MB |
![]() SHA1: b7b34e778f5d4c8dd2f80cf632b76d9ddb616ca0 | 7.15 MB |
![]() SHA1: 855758538020f4cfd528c2b669625e83bfc92046 | 26.92 MB |
![]() SHA1: 8cedba858d2befd9a36ff4531f39be3b186b49e1 | 1.07 MB |
![]() SHA1: 13a0e516bb656e70e3efaf207772e04847332864 | 1.76 MB |
![]() SHA1: ecc7d45cb8a5101396a08ed16fb766f54e31e161 | 1.08 MB |
![]() SHA1: 99425c564af3f7bacb258fdae28d4735e00f4096 | 1.00 MB |
System Requirements
Operating Systems: Windows 7, Windows 8, Windows Server 2003 Service Pack 2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Vista Service Pack 2
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.
Installation Instructions
- NEW COMPONENTS TO THE MICROSOFT SQL SERVER 2012 SP1 FEATURE PACK
Microsoft® Attunity Oracle CDC Designer and Microsoft® Attunity Oracle CDC Service for Microsoft® SQL Server® 2012 SP1- Attunity for Oracle CDC Designer and Service allow you to continually copy data from Oracle to SQL Server. This can be useful in both migration and data warehouse scenarios by allowing you to both; synchronize critical tables throughout the migration timeframe by copying changes made to the Oracle tables into the SQL Server 2012 tables as well as capture changes from your Oracle database and send them to SQL Server 2012 databases to keep data warehouses in sync.
Note:The Microsoft® Attunity Oracle CDC Designer and Microsoft® Attunity Oracle CDC Service for Microsoft® SQL Server® 2012 SP1 End User License Agreements (EULA) can also be downloaded on this page. By downloading and installing the .msi's you are consenting to the terms and conditions included in both licenses.- Filename (X86 and X64 Package)(AttunityOraleCdcService.msi)
Filename (X86 and X64 Package)(AttunityOraleCdcDesigner.msi)- Microsoft® SQL Server® 2012 SP1 PowerPivot® for Microsoft® SharePoint 2013
- Microsoft SQL Server 2012 SP1 PowerPivot for SharePoint 2013 extends SharePoint Server 2013 Preview to add server-side data refresh processing, collaboration, and management support for PowerPivot workbooks and Excel workbooks with advanced data models to SharePoint. This package is only available in a 64-bit version.
Microsoft® SQL Server® 2012 SP1 LocalDB- LocalDB (MSI installer)
New to the SQL Server® Express family, LocalDB is a lightweight version of Express that has the same programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites. Use this if you need a simple way to create and work with databases from code. It can be bundled with Visual Studio, other Database Development tools or embedded with an application that needs local databases.
Microsoft® SQL Server® 2012 SP1 Master Data Service Add-in for Microsoft® Excel®- The Master Data Services Add-in for Excel gives multiple users the ability to update master data in a familiar tool without compromising the data’s integrity in MDS. From within the Add-in, users can publish data to the MDS database with the click of a button. Administrators can use the Add-in to create new model objects and load data without ever launching any administrative tools, helping to speed deployment. With the Master Data Services Add-in for Excel, all master data remains centrally managed in MDS, while the ability to read or update the data is distributed to those who need it.
The Master Data Services (MDS) Add-in for Microsoft Excel is a data management tool that delivers a multitude of master data management capabilities with ease and efficiency. Manage MDS data within an interface you already know and love – Microsoft® Excel. Leverage existing Excel functionality to share your managed lists with others, knowing these lists can be secured and monitored with all of the features provided by Master Data Services.
Microsoft® SQL Server® StreamInsight v2.1- Microsoft® StreamInsight is Microsoft’s Complex Event Processing technology to help businesses create event-driven applications and derive better insights by correlating event streams from multiple sources with near-zero latency.
Microsoft® SQL Server® 2012 SP1 Semantic Language Statistics- The Semantic Language Statistics Database is a required component for the Statistical Semantic Search feature in Microsoft SQL Server 2012. You can download this database from this page, attach it to your SQL Server 2012 SP1 instance, and register it to use the new Semantic Search features.
MICROSOFT SQL SERVER 2012 SP1 ANALYSIS SERVICES FEATURE PACK COMPONENTS- Table Analysis Tools for Excel: This add-in provides easy-to-use tools that leverage SQL Server 2012 SP1 data mining features to perform powerful analytics on your spreadsheet data.
- Data Mining Client for Excel: This add-in enables you to go through the full data mining model development lifecycle within Excel using your spreadsheet data or external data accessible through your SQL Server 2012 SP1 Analysis Services instance.
- Data Mining Templates for Visio: This add-in enables you to render and share your mining models as annotatable Visio drawings.
Microsoft® SQL Server® 2012 SP1 PowerPivot for Microsoft® Excel 2010- Microsoft® PowerPivot for Microsoft® Excel 2010 provides ground-breaking technology, such as fast manipulation of large data sets (often millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through Microsoft® SharePoint 2010.
Microsoft® SQL Server® 2012 SP1 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 2012 SP1 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 2012 languages.- Filename: X86 and x64 Package(SQL_AS_ADOMD.msi)
Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2012 SP1- 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 2012 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 Analysis Services OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0- Filename: X86 and x64 Package(SQL_AS_OLEDB.msi)
Microsoft® SQL Server® 2012 SP1 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.
- Filename: X86 and x64 Package(SQL_AS_AMO.msi)
Microsoft® SQL Server® 2012 SP1 Data Mining Add-ins for Office- The Microsoft SQL Server 2012 SP1 Data Mining Add-ins for Microsoft Office package enables you to take advantage of SQL Server predictive analytics in Office Excel and Office Visio. This release adds support for Office 2013. The download includes the following components:
Microsoft® SQL Server® 2012 SP1 Data Mining Viewer- The Data Mining Web Controls Library was developed to be a set of Microsoft Windows Forms controls that enable software developers to display data mining models created using Microsoft SQL Server 2012 Analysis Services in their client-side applications. The controls in this library display the patterns that are contained in Analysis Services mining models.
The new version (11.0.3129.0) of this msi has been released to address the issue mentioned in KB2793634- Filename: X86 Package(SQL_AS_DMViewer.msi)
Microsoft® SQL Server® Report Builder for Microsoft® SQL Server® 2012 SP1- Report Builder provides a productive report-authoring environment for IT professionals and power users. It supports the full operational reporting capabilities of SQL Server 2012 Reporting Services. The download provides a stand-alone installer for Report Builder.
Microsoft® SQL Server® 2012 SP1 Reporting Services Add-in for Microsoft® SharePoint®- The Microsoft® SQL Server® 2012 SP1 Reporting Services Add-in for Microsoft® SharePoint® 2010 allows you to integrate your reporting environment with SharePoint to experience the benefits of using the collaborative environment provided by SharePoint.
MICROSOFT SQL SERVER 2012 MANAGABILITY FEATURE PACK COMPONENTS
Microsoft® SQL Server® 2012 SP1 Data-Tier Application Framework- The SQL Server Data-tier Application (DAC) framework is a component based on the .NET Framework that provides application lifecycle services for database development and management. Application lifecycle services include extract, build, deploy, upgrade, import, and export for data-tier applications in SQL Azure, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005 through SQL Server Data Tools and SQL Server Management Studio. Note: Microsoft SQL Server 2012 Data-tier Application Framework requires Microsoft SQL Server System CLR Types, and Microsoft SQL Server Transact-SQL ScriptDom both of which are available on this page.
- Filename: X86 and x64 Package(dacframework.msi)
Microsoft® SQL Server® 2012 SP1 Transact-SQL Language Service- The SQL Server Transact-SQL Language Service is a component based on the .NET Framework which provides parsing validation and IntelliSense services for Transact-SQL for SQL Server 2012, SQL Server 2008 R2, and SQL Server 2008.
- Filename: X86 and x64 Package(tsqllanguageservice.msi)
Microsoft® Windows PowerShell Extensions for Microsoft® SQL Server® 2012 SP1- The Microsoft Windows PowerShell Extensions for SQL Server 2012 SP1 includes a provider and a set of cmdlets that enable administrators and developers to build PowerShell scripts for managing instances of SQL Server. The SQL Server PowerShell Provider delivers a simple mechanism for navigating SQL Server instances that is similar to file system paths. PowerShell scripts can then use the SQL Server Management Objects to administer the instances. The SQL Server cmdlets support operations such as executing Transact-SQL scripts or evaluating SQL Server policies.
Note: Windows PowerShell Extensions for SQL Server 2012 requires Microsoft SQL Server 2012 Shared Management Objects, also available on this page. This component also requires Windows PowerShell 2.0; download instructions are on the Windows Server 2003 Web site.- Filename: X86 and x64 Package(PowerShellTools.msi)
Microsoft® SQL Server® 2012 SP1 Shared Management Objects- 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 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.
Note: Microsoft SQL Server Management Objects requires - Microsoft SQL Server System CLR Types. This is available on this page.- Filename: X86 and x64 Package(SharedManagementObjects.msi)
MICROSOFT SQL SERVER CONNECTIVITY FEATURE PACK COMPONENTS
Microsoft® SQL Server® 2012 SP1 Native Client- Microsoft SQL Server 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 2005, 2008, 2008 R2, and SQL Server 2012. SQL Server Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2012 features. This redistributable installer for SQL Server Native Client installs the client components needed during run time to take advantage of new SQL Server code name ‘Denali’ features, and optionally installs the header files needed to develop an application that uses the SQL Server Native Client API.
- Filename: X86 and x64 Package(sqlncli.msi)
Microsoft® SQL Server® 2012 SP1 Command Line Utilities- The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012 instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server 2012 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.
Note: This component requires both Windows Installer 4.5 and Microsoft SQL Server Native Client (which is another component available from this page).- Filename: X86 and x64 Package(SqlCmdLnUtils.msi)
Microsoft® ODBC Driver 11 for SQL Server® - SUSE Linux CTP- The 64 bit version of the Microsoft ODBC Driver 11 for SQL Server provides robust data access to Microsoft SQL Server. It allows native C and C++ applications to leverage the standard ODBC API and connect to Microsoft SQL Server 2012. Microsoft ODBC Driver 11 for SQL Server also comes with powerful tools - sqlcmd and bcp..
Microsoft® JDBC Driver 4.0 for SQL Server®- In our continued commitment to interoperability, Microsoft has released a new Java Database Connectivity (JDBC) driver. The Microsoft JDBC Driver 4.0 for SQL Server is available to all SQL Server users at no additional charge, and provides access to SQL Server 2012 and other versions from any Java application, application server, or Java-enabled applet. This is a Type 4 JDBC driver that provides database connectivity through the standard JDBC Application Program Interfaces (APIs) available in Java Platform, Enterprise Editions 5 and 6. This release of the JDBC Driver is JDBC 4.0 compliant and runs on the Java Development Kit (JDK) version 5.0 or 6.0. It has been tested against major application servers including IBM WebSphere, and SAP NetWeaver.
Microsoft® Drivers 3.0 for PHP for Microsoft® SQL Server®- 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 all editions of SQL Server 2005 and later.
Microsoft® Connector 1.1 for SAP BW for SQL Server® 2012 SP1- The Microsoft Connector for SAP BW is a set of managed components for transferring data to or from an SAP NetWeaver BW version 7.0 system. The component is designed to be used with SQL Server 2012 Integration Services. To install the component, run the platform-specific installer for x86 or x64 respectively. For more information see the Readme and the installation topic in the Help file.
- Filename: X86 and x64 Package(SAPBI.msi)
Microsoft® SQL Server® 2012 SP1 Transact-SQL ScriptDom- Microsoft SQL Server Transact-SQL ScriptDom is a .NET Framework API that provides parsing and scripting services for Transact-SQL. This API supports SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012 versions.
- Filename: X86 and x64 Package(SQLDOM.MSI)
Microsoft® SQL Server® 2012 SP1 Transact-SQL Compiler Service- Microsoft SQL Server Transact-SQL Compiler Service is a set of components that provide the compilation and validation services for Transact-SQL. This component can be used only via the Microsoft SQL Server Data-Tier Application Framework build API.
- Filename: X86 and x64 Package(SQLLS.MSI)
Microsoft® System CLR Types for Microsoft® SQL Server® 2012 SP1- The SQL Server System CLR Types package contains the components implementing the geometry, geography, and hierarchy id types in SQL Server 2012. This component can be installed separately from the server to allow client applications to use these types outside of the server.
Note: This component also requires Windows Installer 4.5- Filename: X86 and x64 Package(SQLSysClrTypes.msi)
SQL Server System CLR Types Books on-line page
Microsoft® SQL Server® 2012 SP1 Remote Blob Store- The SQL Server Remote Blob Store is a method for storing blobs of unstructured data in an external Content Addressable data store. The component consists of a client-side DLL that is linked into a user application, as well as a set of stored procedures to be installed on SQL Server. Run the self-extracting download package to create an installation folder.
- Filename: X86 and x64 Package(RBS.msi)
SQL RBS codeplex samples page
SQL Server Remote Blob Store blogs
Microsoft® SQL Server® Service Broker External Activator for Microsoft® SQL Server® 2012 SP1- The Microsoft SQL Server Service Broker External Activator is an extension of the internal activation feature in SQL Server 2012 that lets you move the logic for receiving and processing Service Broker messages from the Database Engine service to an application executable that runs outside SQL Server. By doing this, cpu-intensive or long-duration tasks can be offloaded out of SQL Server to an application executable, possibly in another computer. The application executable can also run under a different Windows account from the Database Engine process. This gives administrators additional control over the resources that the application can access. Run the self-extracting download package to create an installation folder. Read Books Online for more information. The single setup program will install the service on x86, and x64 computers. Read the documentation for more information.
- Filename: X86 and x64 Package(SSBEAS.msi)
Microsoft® SQL Server® 2012 SP1 Performance Dashboard Reports- The SQL Server 2012 SP1 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature of SQL Server Management Studio. The reports allow a database administrator to quickly identify whether there is a current bottleneck on their system, and if a bottleneck is present, capture additional diagnostic data that may be necessary to resolve the problem.
MICROSOFT SQL SERVER COMPACT FEATURE PACK COMPONENTS
Microsoft® SQL Server® Compact 4.0- Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications. SQL Server Compact 4.0 has a small footprint and supports private deployment of its binaries within the application folder, easy application development in Visual Studio 2010 SP1 and WebMatrix, and seamless migration of schema and data to SQL Server.
Microsoft® SQL Server® Compact 4.0 Books On-line- Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications. Download the documentation to learn about SQL Server Compact 4.0 and to build applications for it.
OTHER MICROSOFT SQL SERVER 2012 COMPONENTS
Microsoft® SQL Server® Migration Assistant- SQL Server Migration Assistant (SSMA) is a family of products to reduce the cost and risk of migration from Oracle, Sybase, MySQL and Microsoft Access databases to SQL server or SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing.
Microsoft® SQL Server® 2012 SP1 Books On-line- Microsoft SQL Server 2012 SP1 Books Online is the primary documentation for SQL Server. Visit the SQL Server Books Online page on the Microsoft Download Center.
Microsoft® SQL Server® 2012 SP1 Upgrade Advisor- Microsoft Upgrade Advisor analyzes instances of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 in preparation for upgrading to SQL Server 2012. 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.
- Filename: X86 and x64 Package(SQLUA.msi)
Microsoft® OLEDB Provider for DB2 v4.0 for Microsoft® SQL Server® 2012- The Microsoft OLE DB Provider for DB2 v4.0 offers a set of technologies and tools for integrating vital data stored in IBM DB2 databases with new solutions. SQL Server developers and administrators can use the data provider with Integration Services, Analysis Services, Replication, Reporting Services, and Distributed Query Processor. Read the Installing Data Provider section of the product documentation, which is available on-line or as a download.
- Filename: X86 and x64 Package(DB2OLEDB.exe)