Unfortunately we never had Sybase ASA on our plans for SSMA. The plan is still intact and we still support migration from Sybase ASE 11.9 onwards with the latest version of SSMA for Sybase http://www.microsoft.com/en-us/download/details.aspx?id=28765...

The %ROWTYPE attribute in Oracle defines the particular record type of a row in a table. A common usage of %ROWTYPE attribute is to have variables declared as ROWTYPE of a table to transfer data in and out of a procedure or function. An IN ROWTYPE parameter...

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

Automating Database Migration to SQL Server 2012 SQL Server Migration Assistant (SSMA) v5.2 is now available. SSMA simplifies database migration process from Oracle/Sybase/MySQL and Microsoft Access to SQL Server and SQL Azure. SSMA automates all aspects...

TechNet Magize published an article which provide overview of SQL Server Migration Assistant (SSMA) features and how it can be used to support database migration to SQL Server. SQL Server: Manage the Migration describes the main feature area of SSMA...

By James Cusick, Imran Riaz, Hubert Huang, Allen Tse, Murugan Gnanavel {james.cusick; imran.riaz; hubert.huang;allen.tse; murugan.gnanavel} @wolterskluwer.com Wolters Kluwer Corporate Legal Services, New York, NY Abstract A common problem in...

Microsoft announced the release of Microsoft Assessment and Planning (MAP) toolkit 6.0. The new version of MAP reports the existence of Oracle database instances and provides information that can be use to estimate total cost of ownership and return-on...

Automating database migration from Oracle, Sybase, MySQL, and Access database to SQL Azure and SQL Server “Denali”. Microsoft announced today the release of SQL Server Migration Assistant (SSMA) v.5.1, a family of products to automate database...

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, but SQL Server "Denali" is changed to 2012. Users should download the lastest SSMA...

[Updated 2/6/2012 Selina Jia - Microsoft SQL Server Migration Assistant (SSMA) for MySQL v5.2. The information provided below is still valid for SSMA for MySQL v5.2, but SQL Server "Denali" is changed to 2012 . Users should download the lastest SSMA for...

SSMA automates conversion of most statement. There are a few features and syntax which SSMA is unable to migrate. In such situation, SSMA issues a migration error and for each error, SSMA provides estimated manual conversion time. I often asked how do...

Microsoft would like to inform customers that support for SSMA v4.2 family of products (including SSMA Extension Packs) is going to end on July 15 th 2012. Following are the products in SSMA v4.2 family of products for which this “End of Support”...

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