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

SSMA Feature Overview

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 including migration assessment, converting database schema, migrating data, and testing database migration. If you prefer…

6

Announcing SQL Server Migration Assistant (SSMA) v.5.1

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 SQL Server Express) and SQL Azure. What’s New in this Release?…

15

How SSMA Estimates Manual Conversion Time

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 time was calculated based…

0

"End of Support" announcement for SQL Server Migration Assistant v4.2 family of products (support ends on July 15th, 2012)

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 15th 2012. Following are the products in SSMA v4.2 family of products for which this “End of Support” notice is applicable: SQL Server Migration Assistant 2005 for Access v4.2 SQL Server…

0

Access to SQL Server Migration: Understanding the Assessment Report and Error List

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 Settings or the Project settings you have set when you run the report. For information regarding the…

3

How to: Migrate to a schema in an existing database using SSMA

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 migration to an existing database with the following…

0

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