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

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

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

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

This video walks you through the schema conversion of SSMA, including an example on how to resolve issue during conversion Check out the other videos in this series: Introduction to SSMA Planning Your Database Migration Analyzing...

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

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.