Part3: Creating a Custom SSMA Report

In the last part of this installment, I will show an example of SSRS report using the data we parsed in part 2 and extracted from SSMA in part1. For this report, I would like to list all projects and its aggregate conversion rate, number of object, and number of errors. If there are multiple runs…


Part2: Creating a Custom SSMA Report

This is part 2 of the article for creating custom SSMA report using SSIS and SSRS. In the previous post, we discussed how to use SSIS package to extract XML files containing SSMA assessment report information into SQL Server table. This week, we will discuss how to parse the XML data. First, let’s create tables…


Part1: Creating a Custom SSMA Report

SSMA provides a migration assessment report to help you identify potential migration issues . You can generate the assessment report by selecting source schema, right click and select Create Report. Alternatively, you can also click on the Create Report button on the top navigation bar. The report provides the information organized by database object types,…


Database Discovery Made Easy with MAP 5.5

Microsoft Assessment and Planning (MAP) is a powerful tool to inventorize, assess and report your IT asset inventory. The new version, MAP 5.5 has new features that automates discovery of heterogeneous database instances for migration to SQL Server. The tool provides network inventory reporting for MySQL, Oracle and Sybase instances in your environment. Once you…


SSMA is now available from WebPI

The Microsoft Web Platform (Web PI) gives you the framework, web server, database and tools you need to build and run Web sites and applications on Windows and SQL Server.  Now the SQL Server Migration Assistant (SSMA) is included as part of Web PI selection below: Once you select and click install, the SSMA tool…


A Curious Case of NUMBER truncation

Oracle’s FLOAT  may truncate a float number beyond its binary digit limit. For example, execute the following in Oracle: DECLARE testvar FLOAT(5); BEGIN Testvar := 123.45; DBMS_OUTPUT.put_line(to_char(testvar)); END;   The statement will return 120 as the number 123.45 is rounded to 120, which has the max 4 binary digit.  This case above is documented here….


"End of Support" for Older SSMA v4.0 family of Products

[ Updated: 2/8/2012 Selina Jia] Microsoft would like to inform customers that support for SSMA v4.0 family of products (including SSMA Extension Packs) is going to end on October 30th 2011. Following are the products in SSMA v4.0 family for which this “End of Support” notice is applicable: 1.       SQL Server Migration Assistant 2005 for…


MySQL to SQL Server 2008 Migration Workshop Video

The following are workshop video series for migrating from MySQL to SQL Server 2008:  Getting Started with SSMA for MySQL This video covers step-by-step instructions on how to install and get up and running with the SSMA tool for MySQL. Note: The video was recorded with SSMA CTP1 version. The full release version of the…


How To Perform Incremental Data Migration Using SSMA

SSMA provides an ability for you to customize sql statement used during data migration. This feature can be used in the following scenarios: Split migration of a large table into multiple iterations Migrate data partially based on specific criteria (e.g. migrate data only for a selected department) To customize data migration sql statement: Modify project…


How To Convert Individual Statement Using SSMA

You can use SSMA to convert a statement (such as PL/SQL) into T-SQL statement using SSMA. This functionality can be used, for example, to convert embedded SQL statement inside an application that connects to the database. Use the following steps to convert individual statement: Open SSMA tool Create a New Project (or open an existing…