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

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

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

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

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

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

[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 session from North America TechEd is now available from Channel 9 .

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

In this blog, I’ll describe how to use SSMA for Access to convert your Jet database for your Microsoft Access solution to SQL Azure . This blog builds on Access to SQL Server Migration: How to Use SSMA using the Access Northwind 2007 template . The blog...

By Mary Chipman In Part 2 I'll continue the discussion about how you can "tread lightly" on your SQL Server by making your Access front end an efficient and economical data consumer. I'll focus on techniques you can use to keep your application...

By Mary Chipman In Part 1 and Part 2 I’ll discuss your options for continuing to use Access as a front-end client once you have migrated the data to SQL Server. Some people come to SQL Server migration as Access developers who are new to SQL Server, whereas...

By Mary Chipman Overview In this blog post I’ll discuss how you can use the SSMA Migration Assistant for Access (SSMA) to refine data type mappings between Access and SQL Server, but first a little history lesson. You can think of Access as...

By Mary Chipman Overview In this blog post I’ll discuss some of the data migration issues you may encounter when migrating your Access schema to SQL Server. These consist of issues that you should address prior to migrating your data, and others are behavioral...

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

[Updated 2/7/2012 Selina Jia- Microsoft SQL Server Migration Assistant (SSMA) for Access v5.2. The information provided below is still valid for SSMA for Access v5.2. Users should download the lastest SSMA for Access] In this blog post I’ll walk...

[ Updated: 2/8/2012 Selina Jia] Microsoft would like to inform customers that support for SSMA v4.0 family of products (including SSMA Extension Packs) is going to end on October 30 th 2011. Following are the products in SSMA v4.0 family for which...

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

Check out video from Joel Shalaby that include a demo on SSMA. SSMA Trailer with customer testimonials. Oracle - SQL Migation Case Study with AON and InfoSys.

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