By Bill Ramos and Vishal Soni , Advaiya Inc. Oracle supports encapsulating variables, types, stored procedures, and functions into a package. When you convert Oracle packages, you need to convert: Procedures and functions - both public and...

SSMA session from North America TechEd is now available from Channel 9 .

        By Bill Ramos and Vishal Soni , Advaiya Inc. This blog covers how the SQL Server Migration Assistant (SSMA) for Oracle uses the SQL Server Common Language Runtime (CLR) User-Defined Types (UDT) for emulating...

SSMA for Oracle requires installation of SSMA Extension Pack on the target SQL Server. This blog post describe errors that you may receive during the installation and how to resolve the issue. Must declare variable error messages During the installation...

SSMA for Oracle and Sybase include tester suite to automate comparison testing between the source and target SQL Server database. The test cases can be defined using Test Case Wizard UI . You can specify database object to test (e.g. function), specify...

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

By Bill Ramos and Mayank Bhanawat , Advaiya Inc. This blog post describes why SQL Server Migration Assistant (SSMA) for Oracle does not convert the PLSQL block when a cursor or cursor variable is passed as a parameter to a function or procedure call....

By Bill Ramos and Mayank Bhanawat , Advaiya Inc. [Updated 2/8/2012 Jiafei Yuan - Microsoft SQL Server Migration Assistant (SSMA) for Oracle v5.2. The information provided below is still valid for SSMA for Oracle v5.2. But there are some difference...

By Bill Ramos and Badal Bordia , Advaiya Inc. This blog post describes why SQL Server Migration Assistant (SSMA) for Oracle doesn’t support the conversion of some of the collection method A collection is an ordered group of elements, all of the same type...

By Bill Ramos and Badal Bordia , Advaiya Inc. [Updated 2/8/2012 Jiafei Yuan - Microsoft SQL Server Migration Assistant (SSMA) for Oracle v5.2. The information provided below is still valid for SSMA for Oracle v5.2. However, with SSMA v5.1, we can leverage...

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 covers the steps involved when migrating database objects (Tables and Indices) from MySQL to SQL . Check out other video in this series: Installing SSMA Migrating Data Resolving Migration Issue

By Bill Ramos and Vishal Soni , Advaiya Inc. This blog post covers some of the reasons why SQL Server Migration Assistant (SSMA) for Oracle cannot convert a statement that contains reference to an Oracle SEQUENCE object. A SEQUENCE is an Oracle object...

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

Oracle supports User Defined Type (UDT) which include object type and collection. This data type is not supported in SQL Server and SSMA does not support conversion of Oracle UDT. You may consider using SQL Server TVP when migrating your Oracle database...

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

This video covers the process of moving data from MySQL to SQL Server 2008 once the database structure has been migrated. Note: SSMA includes an option to do partial data migration. See this blog article on how to modify the...

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

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

This video covers step-by-step instruction 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 tool...

Microsoft Access stores all the connection strings for the respective linked tables in a system table called MSysObjects. As seen below, the connection strings contain clear-text used id and password. With the release for SSMA for Access 5.2, when creating...

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

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 Vishal Soni , Advaiya Inc. This blog post covers some of the reasons why SQL Server Migration Assistant (SSMA) for Oracle cannot convert some of the statements that have the collection or records data-type. This blog also covers the...

By Bill Ramos and Badal Bordia, Advaiya Inc. This blog post describes why SQL Server Migration Assistant (SSMA) for Oracle doesn’t convert the dynamic string within an OPEN...FOR statement and presents a natural alternative to returning cursors by using...