SQL Server Migration Assistant (SSMA) Team's Blog

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

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

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

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

By Bill Ramos, Advaiya Inc. [Updated 2/6/2012 Jiafei Yuan- Microsoft SQL Server Migration Assistant (SSMA) for MySQL v5.2. The information provided below is still valid for SSMA for MySQL v5.2. Users should download the lastest SSMA for MySQL] In...

[Updated 2/7/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. Users should download the lastest SSMA for MySQL] In this blog post, I will describe...

[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. Users should download the lastest SSMA for MySQL] In the blog post MySQL to SQL Server...

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

By Bill Ramos, Advaiya [Updated 2/6/2012 Han Wong - Microsoft SQL Server Migration Assistant (SSMA) for MySQL v5.2. The information provided below is still valid for SSMA for MySQL v5.2. Users should download the lastest SSMA for MySQL] In this...

This video covers common migration issues that a developer may encounter when they migrate from MySQL to SQL Server 2008. Check out other video in this series: Installing SSMA Assessing and Converting MySQL Schema...

This video covers the steps involved when migrating database objects (Tables and Indices) from MySQL to SQL . Check out other video in this series: Installing SSMA Migrating Data Resolving Migration Issue

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