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 of migration including migration assessment...

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 migration to all edition of SQL Server (including...

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 we come up with the time. Those manual estimation...

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” notice is applicable: SQL Server Migration...

SSMA provides a project setting that allow you to customize how the conversion is done. This post describes the project setting options available for you as well as scenarios where you want to customize the setting. SSMA project setting options are categorized into the following: Project...

One of the first decisions you need to make when migrating to SQL Server is to decide whether to migrate to a schema or to a database. There may be different concept of schema between your source database product and SQL Server. Unlike Oracle, for example, schema in SQL Server is not necessarily linked...

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

This video covers the process of moving data from MySQL to SQL Server 2008 once the database structure has been migrated. Note: SSMA includes an option to do partial data migration. See this blog article on how to modify the sql statement to specify subset of data to be migrated...

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

This video covers step-by-step instruction on how to install and get up and running with the SSMA tool for MySQL. Note: The video was recorded with SSMA CTP1 version. The full release version of the tool is now available and can be downloaded from here...

This video introduces SSMA tool including how to download and install as well as provide quick tour of SSMA user interface: Format: wmv Duration: 03:21 Check out the other videos in this series: Introduction to SSMA Planning Your Database Migration Analyzing Database Using SSMA...

Migrate from MySQL to SQL Azure or SQL Server with ease! Microsoft announced today the release of first version of SQL Server Migration Assistant (SSMA) for MySQL! Along with this release, Microsoft refreshed the existing SSMA family of products for Oracle, Sybase and Access with the latest v4...