SQL Server Migration Assistant (SSMA) Team's Blog

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

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

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

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

This video introduces SSMA console application which can automate your SSMA database migration tasks: Format: wmv Duration: 01:52 Detailed walkthough and sample file for using SSMA console application can be found here . Check out the...

This video walks you through database assessment feature of SSMA: Format: wmv Duration: 02:41 Check out the other videos in this series: Introduction to SSMA Planning Your Database Migration Analyzing Database Using SSMA Converting...

One common challenge for a migration project is for a DBA to give password to access a database that he/she owns. This article shows an approach where DBA can keep the password while allowing a separate migration team to run assessment and migration....

SSMA provides a migration assessment report to help you identify potential migration issues . You can generate the assessment report by selecting source schema, right click and select Create Report . Alternatively, you can also click on the Create Report...

In the last part of this installment, I will show an example of SSRS report using the data we parsed in part 2 and extracted from SSMA in part1 . For this report, I would like to list all projects and its aggregate conversion rate, number of object, and...

This is part 2 of the article for creating custom SSMA report using SSIS and SSRS. In the previous post , we discussed how to use SSIS package to extract XML files containing SSMA assessment report information into SQL Server table. This week, we will...