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

By Bill Ramos and Badal Bordia , Advaiya Inc. This blog post covers the reasons why SQL Server Migration Assistant (SSMA) for Oracle cannot get description for packaged function or a packaged procedure call when a parameter has been omitted. A package...

[Updated 2/7/2012 Jiafei Yuan - Microsoft SQL Server Migration Assistant (SSMA) for Sybase v5.2. The information provided below is still valid for SSMA for Sybase v5.2. Users should download the lastest SSMA for Sybase] In this blog, I’m going...

[Updated 2/7/2012 Jiafei Yuan - Microsoft SQL Server Migration Assistant (SSMA) for Sybase v5.2. The information provided below is still valid for SSMA for Sybase v5.2. Users should download the lastest SSMA for Sybase] This blog post explores the...

By Bill Ramos and Mayank Bhanawat , Advaiya Inc. This blog post describes why SQL Server Migration Assistant (SSMA) for Oracle doesn’t support the SAVE EXCEPTION clause in the FORALL statement. Exception handling is a programming language construct or...

By Bill Ramos and Mayank Bhanawat , Advaiya Inc. This blog post describes why SQL Server Migration Assistant (SSMA) for Oracle doesn’t convert the EXIT statement when an outer loop is exited from inside the scope of inner loop. The LOOP statement is used...

By Bill Ramos, Advaiya Inc. In this blog post, I’ll walk through an example of migrating a PHP application originally written for a Windows Apache MySQL PHP server ( WAMP ) onto an IIS server running PHP and SQL Server 2008 R2 Express (often...

By Bill Ramos and Vishal Soni , Advaiya Inc. This blog post covers the reasons why SQL Server Migration Assistant (SSMA) for Oracle does not support Collection or Records Type. A collection is an ordered group of elements, all of the same type. It is...

By Bill Ramos and Mayank Bhanawat , Advaiya Inc. This blog post describes why SQL Server Migration Assistant (SSMA) for Oracle doesn’t support the function statement whenever the number of parameter passed during the function call is less than the expected...

The SQL Server Migration Assistant for Access assessment report displays the results from converting a Jet based Microsoft Access solution to use SQL Server. The report displays errors, warnings, and information settings based on either the Default Project...

When converting Oracle schema to SQL Server using SSMA, you may encounter an error when your table contains a DATE column with default value. This blog post describes the reason for the error and what you should do when you encounter this error. Consider...

SSMA, by default, migrate to dbo schema in a SQL Server database with the same name as source database schema you are migrating from. If the database does not exists, then SSMA will prompt if you like to create a new database. You can modify the target...

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

When performing migration assessment for a large schema (with thousands of objects), you can use the following to help improve performance: Run SSMA application on hardware with x64 bit Windows and memory of at least 4 GB. Force load the schema...