Planning For SQL Server 2005 End Of Support Part 2

  • Article

In the first post of this series I covered the different SQL editions that are impacted by the April 12, 2016 end of support deadline, and introduced the Microsoft Assessment and Planning Toolkit. In this post I'll cover the MAP Toolkit in more detail, including what's included with the most recent updates that are relevant for SQL Server 2005 end of support engagements. Most of updates to the MAP Toolkit usually involve new upgrade scenarios that Microsoft is focused on, such as the inclusion of Windows 10 as a mgiration target in the 9.3 release, but I strongly recommend using the latest version to make sure you've got the best coverage. It's worth keeping an eye on the MAP Blog to be kept up to date on new releases, but I'll try to make sure that I include those updates here as well.

Even though MAP 9.3 is available for download today, back in MAP 9.1 there was improved SQL Server discovery capabilities added, so that the discovery of components installed without the database engine could be captured. This means that installations of SQL Server Reporting Services, for example, will be included in the SQL Discovery Report, to help make sure components installed on non-database servers can also be assessed for upgrade. The 9.1 update also included other updates, including additional support for SQL Server 2012 services and SQL 2014.

Here is some additional information from the MAP team on what they provide for SQL Server migrations, as well as some general information on downloading and installing.

Accelerate your migration to SQL Server

Get a complete network-wide inventory of SQL Server and Oracle instances, edition identification, and hardware assessment, when you use MAP as part of a comprehensive process for planning and migrating legacy database instances to the latest version of SQL Server. The wide-ranging details of databases and server instances MAP provides is information that you can use to consolidate databases and better utilize hardware and database resources.

With MAP you get the following reports for migration to the latest version of SQL Server:

  • Discovery and inventory: Database inventory and reporting of SQL Server and Oracle instances on Windows and Linux based servers and Oracle schemas in your organization.
  • Detailed reporting: Covers specific SQL Server instances that include component name, version, edition, and more. Includes wide-ranging details of databases and server instances that can be used for consolidation. Oracle schema reportingidentifies the size and use of each schema, estimates of the complexity of migration which may suggest candidates for migration to SQL Server. This information can be used to determine the total cost of ownership in maintaining Oracle and the potential ROI from switching to SQL Server.
  • Hardware and platform details: Details for computers that are running heterogeneous database instances, including determining whether the machines are virtual or physical.

MAP Download Center page

The Microsoft Assessment and Planning Toolkit makes it easy to assess your current IT infrastructure for a variety of technology migration projects. This Solution Accelerator provides a powerful inventory, assessment, and reporting tool to simplify the migration planning process.

The Microsoft Assessment and Planning Toolkit (MAP) is an agentless, automated, multi-product planning and assessment tool for quicker and easier desktop, server and cloud migrations. MAP provides detailed readiness assessment reports and executive proposals with extensive hardware and software information, and actionable recommendations to help organizations accelerate their IT infrastructure planning process, and gather more detail on assets that reside within their current environment. MAP also provides server utilization data for Hyper-V server virtualization planning; identifying server placements, and performing virtualization candidate assessments. Learn more.

The MAP Toolkit includes the following components:

  • MAPSetup.exe. Installation package containing the tool and SQL LocalDB.
  • readme_en.htm. Available as a separate download. Provides information to read before installing the MAP Toolkit, including installation prerequisites and known issues.
  • MAP_Sample_Documents.zip. Available as a separate download. Contains sample reports and proposals.
  • MAP_Training_Kit.zip. Available as a separate download. Contains sample database and instructions for completing various exercises.

Supported Operating System

Windows 10 , Windows 7 Service Pack 1, Windows 8, Windows 8.1, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2

Hardware Requirements:

    • A computer with at least the following minimum configuration:
      • A dual-core 1.5GHz processor
      • 2.0 GB of RAM
      • 1 GB of available disk space
      • Network adapter card
      • Graphics adapter that supports 1024x768 or higher resolution. At 1024x768, using a DPI setting of more than 100% is not supported. At higher resolutions, DPI settings higher than 100% are supported.

Note:

    • Inventory, assessment, and reporting performance are based primarily on the speed of the CPU and the amount of available RAM.

Software Requirements:

      • Operating system. Any of the following:
      • Windows 10 (Professional, Enterprise and Ultimate editions only)
      • Windows 8.1 (Professional and Enterprise editions only)
      • Windows 8 (Professional and Enterprise editions only)
      • Windows 7 with Service Pack 1 (Professional, Enterprise, and Ultimate editions only)
      • Windows Server 2012 R2
      • Windows Server 2012
      • Windows Server 2008 R2 with Service Pack 1

    • .NET Framework 4.5 (download from https://go.microsoft.com/fwlink/?LinkId=389161)

    • Installation of all updates for the operating system. Note: In some cases updates may not install automatically. To download updates for your computer manually, go to https://update.microsoft.com.

    • By default, the MAP Toolkit will install SQL Server 2012 Express LocalDB during setup. You may also use an existing installation of SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012 if you create an instance named "MAPS" before running the MAP Toolkit installer. The MAP Toolkit requires the collation order of the database engine to be set to "SQL_Latin1_General_CP1_CI_AS".

  • Notes:

    • Some of these prerequisites require restarting your computer. You may have to restart multiple times if all the prerequisites are not met prior to running Microsoft Assessment and Planning Toolkit setup.

  • Scenario-dependent requirements:

    • For machines that will be used to run the Forefront Endpoint Protection Usage Tracking, Lync Usage Tracking, Exchange Server Usage Tracking, or Volume Licensing scenarios, please note: PowerShell 2.0 or higher must be installed.
    • For machines that will be used to collect Oracle schema information, please note: The 64 bit Oracle client must be installed on the MAP machine to collect the schema information. If the 64 bit client is not installed, MAP will only be able to collect instance information. MAP will not collect schema information if the 32 bit Oracle client is installed.
    1. Click the Download files below link in the Quick Details section near the top of the page to view the files to download.
  1. Download and read the readme.en.htm for installation instructions and known issues.
  2. Download and execute the Microsoft Assessment and Planning Toolkit setup wizard to install the Solution Accelerator.

MAP Toolkit Support:

Online Resources:

Contact us:

Other Resources: