Learn About SSMA for Access

Leverage these resources to see how SQL Server Migration Assistant automates, streamlines, and simplifies data migration and helps bring data management, rich data analysis, and data-mining capabilities to your business. Get the SSMA for Access Readme file.

New! Watch these starter videos to learn about SSMA for Access
SSMA for Access FAQ

Getting Started with SQL Server Migration Assistant for Access (SSMA Access)

Starter video tutorial provides step-by-step instructions demonstrating the process of converting an Access database to SQL Server database using SSMA (SQL Server Migration Assistant) for Access.

Lesson 1: Overview and Installation
This lesson covers an overview of the tool and reasons for migration to SQL Server. Users will learn about high-level features of SSMA Access and the typical migration scenarios supported by SSMA Access. The lesson explains the minimum requirements for installation and versions of Access supported. It also demonstrates how to download and install SSMA Access and obtain a license key.
Duration: 13 minutes 30 seconds (12.2 MB)
Watch the Video | Download the Video
Lesson 2: Migration Process and Settings
This lesson walks through each step of the migration wizard and discusses various options and impact of decisions made during migration. Users will also learn about the most important configuration options and how they impact the migration process.
Duration: 15 minutes 40 seconds (10 MB)
Watch the Video | Download the Video
Lesson 3: Migration Review and Considerations
Users will learn how to assess the status of their migration and how to diagnose and identify issues. This lesson also discusses some of the top issues related to database conversions and provides references for further learning.
Duration: 16 minutes 30 seconds (15.8 MB)
Watch the Video | Download the Video