SSMA @TechEd Video

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

Migrating Oracle to SQL Server Using SSMA – Emulating Oracle Package Variables

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 private Variables Cursors Initialization routines This blog describes how SQL Server Migration Assistant (SSMA) for Oracle converts package…


Migrating Oracle to SQL Server using SSMA–Error O2SS0293: Columns list in set clause cannot be converted

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    (        ACCOUNT_ID NUMBER NOT NULL,        ACCOUNT_OWNER VARCHAR2(30) NOT NULL    ); UPDATE ACCOUNT     SET (ACCOUNT_ID, ACCOUNT_OWNER)…

Saving Comments During Migration

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 that is part of the table/ column schema. SQL Server Migration Assistant (SSMA)…


Video: Converting Schema to SQL Server

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 Database Using SSMA Converting Schema to SQL Server Migrating Data Using SSMA Automating Database Migration Using SSMA Console…


A Foreign Affair

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 by the Oracle client provider not able to process SQL statement containing non-ASCII characters. In…

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

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…