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

[Update: 2/9/2012 Selina JIa-Microsoft SQL Server Migration Assistant (SSMA) for Access v5.2] In many cases, the Migration Wizard for Access will successfully migrate your Jet based Access solution to SQL Server. You may find a need to change your...

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

[Updated: 2/8/2012 Selina Jia- the latest SSMA is v5.2, which has no Provider option in the project settings , so below cannot be applied to SSMA 5.2. But, if you don't want to use initial Provider to migrate data, you can change it in below dialog...

[Updated: 2/9/2012 Selina Jia] SSMA provide an option to automatically create a link table for every table it moves to SQL Server. This is a useful functionality to allow all forms, reports, and query that refers to the table still work after the data...

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 .

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

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

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

By Bill Ramos and Ankit Matta , Advaiya Inc. This blog post covers why SQL Server Migration Assistant (SSMA) for Oracle cannot convert a procedure that contains the CURSOR as parameter. A cursor is a mechanism by which you can assign a name to a "SELECT...

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

By Bill Ramos and Badal Bordia , Advaiya Inc. This blog post covers 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 you can...

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

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 BULK COLLECT INTO Clause (a collection category query). A collection...

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 Ankit Matta , Advaiya Inc. This blog post describes why SQL Server Migration Assistant (SSMA) for Oracle doesn’t convert the statement having Cursor attributes with any conditional operator. A CURSOR is a mechanism by which you can assign...

By Bill Ramos and Vishal Soni Advaiya Inc. [Updated 2/7/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. Users should download the lastest...