MySQL to SQL Server Migration: How to Use SSMA

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 blog, I’m going to walk you through the process of converting the MySQL Sakila-DB sample database to…

30

Video: Resolving Migration Issue in MySQL

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 Migrating Data


Video: 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


How To Convert Individual Statement Using SSMA

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 convert individual statement: Open SSMA tool Create a New Project (or open an existing…

2