SQL Server Migration Assistant (SSMA) Team's Blog

By Bill Ramos and Mayank Bhanawat Advaiya Inc. This blog post covers why SQL Server Migration Assistant (SSMA) for Oracle doesn’t convert the PL/SQL blocks when SELECT statement is used with BULK COLLECT INTO clause and DISTINCT clause. A collection is...

This blog post describes SSMA error message when converting Oracle PL/SQL UPDATE statement with column group assignment. Oracle PL/SQL allows you to perform multi column update through sub-query. Consider the following example: CREATE TABLE ACCOUNT...

By Bill Ramos and Mayank Bhanawat Advaiya Inc. This blog post covers some of the reasons why SQL Server Migration Assistant (SSMA) for Oracle doesn’t convert the PL/SQL blocks containing PRAGMA AUTONOMOUS_TRANSACTION statement on the block level (i.e...

By Bill Ramos and Ankit Matta, Advaiya Inc. This blog post covers some of the reasons why SQL Server Migration Assistant (SSMA) for Oracle cannot convert a statement that contains the Oracle ROWNUM in ORDER BY clause. The Oracle ROWNUM returns a number...

By Bill Ramos and Ankit Matta, Advaiya Inc. This blog post covers some of the reasons why SQL Server Migration Assistant (SSMA) for Oracle cannot convert a statement that contains the Oracle ROWNUM pseudocolumn. The Oracle ROWNUM returns a number indicating...

SSMA provides flexibility for you to migrate your data with one of the two options below: Client side data migration engine : This option migrate data through the client machine where SSMA is installed and provides a quick and easy way to migrate...

SSMA provides a project setting that allow you to customize how the conversion is done. This post describes the project setting options available for you as well as scenarios where you want to customize the setting. SSMA project setting options...

One of the first decisions you need to make when migrating to SQL Server is to decide whether to migrate to a schema or to a database. There may be different concept of schema between your source database product and SQL Server. Unlike Oracle, for example...

During migration to SQL Server, you may find that the source database schema contains some comments to describe the schema. This can be as a comment within programming code (such as Oracle PL/SQL) in procedure, function, package, view or as a comment...

This video introduces SSMA tool including how to download and install as well as provide quick tour of SSMA user interface: Format: wmv Duration: 03:21 Check out the other videos in this series: Introduction to SSMA Planning Your...

This video introduces SSMA console application which can automate your SSMA database migration tasks: Format: wmv Duration: 01:52 Detailed walkthough and sample file for using SSMA console application can be found here . Check out the...

This video describes how to migrate data using SSMA: Format: wmv Duration: 01:43 Check out the other videos in this series: Introduction to SSMA Planning Your Database Migration Analyzing Database Using SSMA Converting Schema...

This video walks you through the schema conversion of SSMA, including an example on how to resolve issue during conversion Check out the other videos in this series: Introduction to SSMA Planning Your Database Migration Analyzing...

This video walks you through database assessment feature of SSMA: Format: wmv Duration: 02:41 Check out the other videos in this series: Introduction to SSMA Planning Your Database Migration Analyzing Database Using SSMA Converting...

This video provides a quick overview of planning your database migration and setting up your SSMA, including connecting to your databases and configuring SSMA project setting. Format: wmv Duration: 02:27 Check out the other videos in this...

One common challenge for a migration project is for a DBA to give password to access a database that he/she owns. This article shows an approach where DBA can keep the password while allowing a separate migration team to run assessment and migration....

The next version of the Microsoft Assessment and Planning (MAP) Toolkit—version 5.5— is now available for free download. · Download MAP 5.5 Simplify planning for migration to the latest Microsoft products and technologies with...

You may run into issue when using SSMA to connect to Oracle database containing foreign characters (non-ASCII characters) in its schema. In the example below, we have an Oracle database containing a table with Japanese name: The issue is caused...

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...

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...

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...

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...

[ 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 30 th 2011. Following are the products in SSMA v4.0 family for which...

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...

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...