Microsoft announced the release of Microsoft Assessment and Planning (MAP) toolkit 6.0. The new version of MAP reports the existence of Oracle database instances and provides information that can be use to estimate total cost of ownership and return-on-investment (ROI) for migrating the Oracle schema to SQL Server.

You can download MAP 6.0 from Microsoft Solution Accelerators product web site. After configuring and running the assessment, you can view a summary of Oracle instances found by the tool through “Oracle Discovery” menu. This report provides a breakdown on the different instance by Oracle version and the host operating system summary.

MAP_OracleReport

You can get more detailed information by generating report through the Actions > Tasks > Generate report/proposal. After the report is generated, you can access the report through View > Saved reports and proposal menu item. Alternatively, you can also access the reports from My Documents\MAP folder.

There are two reports generated:

  1. SQL Migration Discovery Summary
  2. SQL Migration Proposal

MAP_report_types

SQL Migration Discovery Summary

This report provides detailed information on the database instances found in your  environment. There are several tabs in this excel report:

  • SQL Migration Discovery Summary : List the different database by product and host operating system

summary_1

  • Oracle Instance Summary: List the installation and hardware profile of the database instances

summary_2

  • Oracle Products: List Oracle instances with product edition, version, and status

summary_3

  • Oracle Options: List Oracle instances with installed options and status (true/false)

summary_4

  • Oracle Schemas: List Oracle instances with counts of different object types

summary_5

SQL Migration Proposal

This is a report that you can use as a starting point for preparing database migration proposal. The report is populated with a summary information from the excel report. There are two table included in the word document:

  • Oracle instances with highest potential ROI following migration to SQL Server (Table 6)
  • Oracle instances with lowest complexity (Table 7)

proposal_1

proposal_2

Table 7 rank the discovered Oracle schema based on the fewest number of database objects. Many organization pilot database migration project by picking a simpler database. The list of Oracle schemas listed on the table can help you to identify these “low hanging fruit” projects.

Note that the schema complexity is determined by the database object counts. In order to assess the complexity of the PL/SQL program, you should follow up the assessment by running SQL Server Migration Assistant (SSMA). SSMA provides comprehensive assessment of the complexity of the program and statements stored in the Oracle schema. The list of schema identified by MAP helps to narrow down the list of schemas to do deeper analysis through SSMA.

Summary

MAP 6.0 is a great tool that you can use to help you to analyze and plan for your database migration project. The tool can help you to collect information that you may use the calculate the total cost of ownership for the Oracle databases and identified the candidate schema you may select for pilot migration project.