Servers

    Microsoft SQL Server Migration Assistant v6.0 for Access

    Language:
    English
    Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool to automate migration from Microsoft Access database(s) to SQL Server and Azure SQL DB.
    • Version:

      6.0

      File Name:

      SSMA for Access.6.0.0.exe

      Date Published:

      7/23/2014

      File Size:

      7.0 MB

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

        SSMA for Access v6.0 is designed to support migration from Microsoft Access 97 and higher to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and Azure SQL DB.
    • Supported Operating System

      Windows 7, Windows 8.1, Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2

        • Windows 7, Windows 8.1, Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012R2.


        Requirements for the SSMA for Access client:
        • Microsoft Windows Installer 3.1 or a later version.
        • The Microsoft .NET Framework version 4.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 or 14.0. You can install DAO provider from Microsoft Office 2010/2007 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.
      • After the download, you must extract the installation files before you can install SSMA for Access.

        Installing the SSMA for Access Client
        1. Double-click SSMA for Access.exe.
        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.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial