Forum Discussion

malcolm_p_galvin_jr's avatar
malcolm_p_galvin_jr
Copper Contributor
Aug 16, 2021

Access to SQL

The SQL Server Migration Assistant for Access website states:

  • Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool for migrating databases from Microsoft Access versions 97 through 2010 to SQL Server 2012, Microsoft SQL Server 2014, Microsoft SQL Server 2016, MicrosoftSQL Server 2017 on Windows and Linux, MicrosoftSQL Server 2019 on Windows and Linux, or Microsoft Azure SQL Database.

I began writing an Access application in 2000 and updated it through 2010, using the newest versions of Access at the time.  I now run the application on my current Access 2019.   All my Access files are .mdb files.

I have downloaded Microsoft SQL Server 2019 Express edition.

 

Based on the above, should I be able to use SSMA for the migration?

access
  • Paolo-ZH's avatar
    Paolo-ZH
    Copper Contributor
    Aug 21, 2021
    I have already migrated countless Access databases with different versions to different SQL Server versions and don't know any reason why this should not work for you.

Resources