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. This blog post describes why SQL Server Migration Assistant (SSMA) for Oracle doesn’t convert the PL/SQL block when package variable holds an unsupported datatype such as INTERVAL datatype. In Oracle INTERVAL...

By Bill Ramos and Ankit Matta , Advaiya Inc. This blog post covers the reasons why SQL Server Migration Assistant (SSMA) for Oracle Cannot Convert Standalone User-Defined Types.   A User Defined Type (UDT) is an entitled data type that is made in...

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

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

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

By Welly Lee, Pinaki Bag, and Jayakumar Tanneru. Oracle has an object data type called anydata . This data type supports wide range of data types. For example when creating a table with a column defined as anydata type, the column can store many types...

By Bill Ramos and Badal Bordia , Advaiya Inc. This blog post covers the reasons why SQL Server Migration Assistant (SSMA) for Oracle does not support comparison of Records or collection variables. A collection is an ordered group of elements, all of the...

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 Gowri Shanker and Welly Lee. This blog post discusses approaches to migrate Oracle Materialized View to SQL Server. We compare Materialized View with SQL Server Indexed View, discuss scenarios supported by Indexed View and provide suggestions you...

By Bill Ramos and Badal Bordia , Advaiya Inc. This blog post covers the reason why SQL Server Migration Assistant (SSMA) for Oracle is not able to convert the record set which is returned as the return type of the function. A Function is a block of code...

  By Bill Ramos and Vishal Soni , Advaiya Inc. This blog post describes why SQL Server Migration Assistant (SSMA) for Oracle gives an error when converting the CLOSE and FETCH…INTO statements in a procedure where a SYS_REFCURSOR is returned as parameter...

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

By Bill Ramos and Ankit Matta , Advaiya Inc. This blog post covers the reason why SQL Server Migration Assistant (SSMA) for Oracle cannot convert EXCEPTION_INIT. Exception handling is a programming language construct or mechanism designed to handle the...

By Bill Ramos and Vishal Soni , Advaiya Inc. This blog post covers the reason why SQL Server Migration Assistant (SSMA) for Oracle cannot convert EXCEPTION_INIT. Exception handling is a programming language construct or mechanism designed to handle the...

By Bill Ramos and Mayank Bhanawat , Advaiya Inc. This blog post describes why SQL Server Migration Assistant (SSMA) for Oracle doesn’t convert the PL/SQL block when outer joins are used in hierarchical queries. In Oracle, CONNECT BY PRIOR is a condition...

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

By Bill Ramos and Ankit Matta , Advaiya Inc. This blog post covers the reason why SQL Server Migration Assistant (SSMA) for Oracle does not convert the wrapped code. Wrapping (encrypting) is a process of hiding the source code. Wrapping helps to protect...

MySQL provides STR_TO_DATE() standard function which convert string into date type. SSMA does not support conversion of STR_TO_DATE() function and when it encounters call to the function, SSMA generates a conversion error message "M2SS0201: MySQL standard...

By Bill Ramos and Ankit Matta , Advaiya Inc. This blog post covers one of the reasons why SQL Server Migration Assistant (SSMA) for Oracle cannot convert a hierarchical query containing complex functions in any sub query. A hierarchical query is a type...

By Bill Ramos and Ankit Matta , Advaiya Inc. This blog post covers the reason why SQL Server Migration Assistant (SSMA) for Oracle is not able to convert a BINARY_FLOAT column with a constraint for checking a NAN ( Not a Number ) condition. In Oracle...

By Bill Ramos and Vishal Soni , Advaiya Inc. This blog post covers the reason why SQL Server Migration Assistant (SSMA) for Oracle cannot convert some of the statements that have cursor as a return type in any function. A cursor is a mechanism by which...

By Bill Ramos and Vishal Soni , Advaiya Inc. This blog post describes why SQL Server Migration Assistant (SSMA) for Oracle doesn’t convert the PL/SQL block when using invalid syntax while creating a package in Oracle code. Error O2SS0418 Failed to parse...

By Bill Ramos and Mayank Bhanawat , Advaiya Inc. This blog post describes why SQL Server Migration Assistant (SSMA) for Oracle doesn’t convert the SELECT statement in two scenarios that have ill formed ORDER BY clauses. Error O2SS0160 SELECT statement...