Based on requirements to install SQL Server 2012 Developer Training Kit (right, part of those requirements are only my scary Halloween imagination) – some words in previous post – I decided to install almost all addictional software. In worse case scenario (I’m pesimist since my birthday) I’ll reinstall my system – it’s not virtual. In best case scenario: nothing will happen.
First part based on Microsoft® SQL Server® code name ‘Denali’ Community Technology Preview 3 (CTP 3) Feature Pack. The smallest phase of One-Third phase of First Phase are below (in sweet sixteen steps). I hope it will help You with plan for installation (almost all description are copied from Microsoft site).
Step.01 | Data-Tier Application Framework CTP 3 >> 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 code named ‘Denali’ CTP 3, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, and limited support for SQL Server 2000. | DOWNLOAD: dacframework.msi X86 Package or X64 Package
Step.02 | Transact-SQL Language Service CTP 3 >> 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 code name ‘Denali’ CTP 3, SQL Server 2008 R2, and SQL Server 2008 | DOWNLOAD: tsqllanguageservice.msi X86 Package or X64 Package
Step.03 | Transact-SQL ScriptDom CTP 3 >> 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 code name ‘Denali’ CTP 3 versions. | DOWNLOAD: SQLDOM.msi X86 Package or X64 Package
Step.04 | Connector 1.1 for SAP BW for SQL Server® code name ‘Denali’ CTP 3 > 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 with the SQL Server code name ‘Denali’ CTP 3 Integration Services | DOWNLOAD: AspBI.msi X86 Package or X64 Package
Step.05 | System CLR Types for SQL Server® code name ‘Denali’ CTP 3 >>The SQL Server System CLR Types package contains the components implementing the geometry, geography, and hierarchy id types in SQL Server code name ‘Denali’ CTP 3. This component can be installed separately from the server to allow client applications to use these types outside of the server. | DOWNLOAD: BISQLSysClrTypes.msi X86 Package or X64 Package
Step.06 | Remote Blob Store CTP 3 >> 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. | DOWNLOAD: RBS.msi X86 Package or X64 Package and CodePlex Sample Page
One exeption for RBS – because I use only Express Editions and don’t want to use large objects now (who knows what will be tomorrow) I missed this installation.
Step.07 | Native Client CTP 3 >> 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 2000, 2005, 2008 and 2008 R2. SQL Server Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server code name ‘Denali’ 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. | DOWNLOAD: sqlncli.msi X86 Package or X64 Package
Step.08 | Command Line Utilities CTP 3 >> The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server 7.0, SQL Server 2000, SQL Server 2005, and SQL Server 2008, 2008 R2, and ‘Denali’ CTP 3 instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server code name ‘Denali’ CTP 3 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. | DOWNLOAD: SqlCmdLnUtils.msi X86 Package or X64 Package
Step.09 | Service Broker External Activator >> The Microsoft SQL Server Service Broker External Activator is an extension of the internal activation feature in SQL Server code name ‘Denali’ 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. | DOWNLOAD: SSBEAS.msi X86 Package or X64 Package
Step.10 | Upgrade Advisor CTP 3 >> Microsoft Upgrade Advisor analyzes instances of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 in preparation for upgrading to SQL Server code name ‘Denali’. 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. | DOWNLOAD: SSBUA.msi X86 Package or X64 Package
Step.11 | PowerShell Extensions >> The Microsoft Windows PowerShell Extensions for SQL Server code name ‘Denali’ 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. | DOWNLOAD: PowerShellTools.msi X86 Package or X64 Package
Step.12 | ADOMD.NET CTP 3 >> 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 code name ‘Denali’ CTP 3 Analysis Services. ADOMD.NET is a Microsoft ADO.NET provider with enhancements for online analytical processing (OLAP) and data mining. | DOWNLOAD: SQLSERVER2008_ASADOMD10.msi X86 Package or X64 Package
Step.13 | Analysis Management Objects CTP 3 >> 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. | DOWNLOAD: SQLSERVER2008_ASAMO10.msi X86 Package or X64 Package
Step.14 | Transact-SQL Compiler Service CTP 3 >> 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. | DOWNLOAD: SQLLS.msi X86 Package or X64 Package
Step.15 | Shared Management Objects CTP 3 >> 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 code name ‘Denali’ CTP 3. | DOWNLOAD: SharedManagementObjects.msi X86 Package or X64 Package
Step.16 | Analysis Services OLE DB Provider CTP 3 >> 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 code name ‘Denali’ CTP 3 Analysis Services. This provider implements both the OLE DB specification and the specification’s extensions for online analytical processing (OLAP) and data mining. | DOWNLOAD: SQLServer2008_ASOLEDB.msi X86 Package or X64 Package
Of course it is just beginning. We can use (from this Feature Pack) some other tools such as Microsoft® Drivers 3.0 for PHP for SQL Server® CTP1 (unfortunately still for CTP1 version) and Microsoft® OLEDB Provider for DB2 v4.0 for SQL Server code name ‘Denali’ CTP 3 and of course 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.
1. Microsoft SQL Server Migration Assistant for Access
2. Microsoft SQL Server Migration Assistant for MySQL
3. Microsoft SQL Server Migration Assistant for Oracle
4. Microsoft SQL Server Migration Assistant for Sybase
5. Microsoft SQL Server Migration Assistant for Sybase PowerBuilder Applications
So. As we see we have a lot of “SQL Server Area” software which could be interesting, important and/or necessary for learning time. In this “phase of phases” I wrote about simple (except RBS) clicking applications and features, available for direct download from THIS site. In next I wrote about fatures available from personalized sites.