Latest Update – Microsoft SQL Server Migration Assistant (SSMA) v6.0 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 analysis, schema and SQL statement conversion, data migration as well as migration testing to reduce cost and reduce risk of your database migration project.    The new version of  SSMA,…

24

Microsoft SQL Server Migration Assistant (SSMA) v5.3 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 analysis, schema and SQL statement conversion, data migration as well as migration testing to reduce cost and reduce risk of your database migration project.  The new version of SSMA -…

19

Microsoft SQL Server Migration Assistant (SSMA) 5.2 is Now Available

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 analysis, schema and SQL statement conversion, data migration as well as migration testing to…

65

Access to SQL Server Migration: Understanding SSMA Project Settings

[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 project options for the desired result. In this blog, I’ll describe how to use the project options…

0

Migrating Access Jet Databases to SQL Azure

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 also assumes that you have a SQL Azure account setup…

0

Access to SQL Server Migration: Understanding Data Type Conversions

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 two separate products rolled into one: the relational database engine, Jet, consisting…

5

Access to SQL Server Migration: Handling Schema Migration Issues

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 differences that you should be aware of. In my experience, it’s…

3

Video: Migrating Data Using SSMA

This video describes how to migrate data using SSMA:   Check out the other videos in this series: Introduction to SSMA Planning Your Database Migration Analyzing Database Using SSMA Converting Schema to SQL Server Migrating Data Using SSMA Automating Database Migration Using SSMA Console Application

0

Access to SQL Server Migration: How to Use SSMA

[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 through the process of migrating the Access 2007 Northwind database to SQL Server using the SQL Server…

8

SQL Server Migration Videos

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.

3