Microsoft Download Center Archive

Microsoft SQL Server Migration Assistant for Access

  • Published:
  • Version: 10.4
  • Product: Servers
  • Language: English

Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool to automate migration from Microsoft Access database(s) to SQL Server, Azure SQL Database and Azure SQL Database Managed Instance.

SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Access to SQL Server, Azure SQL Database and Azure SQL Database Managed Instance. SSMA for Access automates conversion of Microsoft Access database objects to SQL Server, Azure SQL Database or Azure SQL Database Managed Instance objects, loads the objects and migrates data to the target database.

SSMA for Access is designed to support migration from Microsoft Access 97 and higher to all editions of SQL Server 2016 onwards, Azure SQL Database and Azure SQL Database Managed Instance.

Files

Status: Live

This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

Files
SSMAforAccess_9.5.0.msi
    SSMAforAccess_9.5.0_x86.msi

      File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

      System Requirements

      Operating Systems: Windows 10, Windows 8.1, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, Windows 7, Windows Server 2008 R2, Windows 8

      • Windows 10+, Windows Server 2016+

      Requirements for the SSMA for Access client:
      • The Microsoft .NET 8.0 or a later version. You can obtain it from the .NET Framework Developer Center.
      • Access to and sufficient permissions on the computer that hosts the target instance of SQL Server.
      • DAO provider version 12.0, 14.0 or 16.0. You can install DAO provider from Microsoft Office product or download it from Microsoft web site.
      • Microsoft SQL Server Native Client (SNAC) version 10.5 and above. You can install SNAC from Microsoft SQL Server web site as part of SQL Server Feature Pack.
      • 4 GB RAM.

      Installation Instructions

      After the download, you must install SSMA for Access.

      Installing the SSMA for Access Client

      1. Double-click SSMAforAccess_n.msi, where n is the version number.
      2. On the 'Welcome' page, click Next.
      3. If you do not have the prerequisites installed, a message will appear that indicates that you must first install required components. Make sure that you have installed all prerequisites, and then run the installation program again.
      4. Read the End User License Agreement. If you agree to the terms, select "I accept the agreement" option and click Next.
      5. On the 'Choose Setup Type' page, click Typical.
      6. Click Install.

      What is this?

      Microsoft regularly deletes downloads for prior versions of Windows, Office, Visual Studio, SQL Server, and countless other products from their Download Center website. Legacy Update catalogues downloads that have been deleted from Microsoft Download Center since 2012.

      Check our Microsoft Download Center Archive homepage or click Random to discover more downloads.

      Deleted downloads are no longer supported by Microsoft, and may have known security vulnerabilities. After installing, check for updates using Legacy Update.

      This page was generated from a snapshot of the Microsoft Download Center made on .