United States   Change   |   All Microsoft Sites

Home - SQL Server 2005

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.

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

SSMA for Access: Frequently Asked Questions

Learn more about using SQL Server Migration Assistant (SSMA) for Access by reading this frequently asked questions page.

View all answers

Q.  What is SSMA for Access?

Q.  What Access and SQL Server versions are supported?

Q.  Can I use my existing Access applications with databases that are migrated to SQL Server 2005?

Q.  Why should I use SSMA for Access instead of the Office Upsizing Wizard?

Q.  What are the migration steps?

Q.  Does SSMA for Access convert the Access application front-end to a Visual Studio 2005 application?

Q.  Will my application continue to work after the migration?

Q.  How do I get support?

Q.  What is the difference between SSMA for Access version 1.2 and SSMA for Access version 4?

Migration for Access