Using SQL Server migration assistant for access to create a SQL Server 2008r2 database from an Access database RRS feed

  • Question

  • I would like to know if anyone has a copy of a previous version of the Microsoft SQL Server migration assistant for access that will allow me to migrate an Access database that I have over to SQL Server 2008r2. The current version only supports creating 2012-2019 databases, but previous version did allow for creating databases on SQL Server 2008r2. Or if there is another way to use the current version of SQL Server migration assistant for access (7.11) and have it create a compatible SQL Server 2008r2 database upon conversion. Unfortunately we are still using SQL Server 2008r2 in our production environment, but hopefully we will be migrating to SQL Server 2016 soon, until then we are tied down to SQL Server 2008r2.

    Thank you for your time and considerations,


    Monday, November 5, 2018 5:28 PM


All replies

  • Hi -Kasey,

    Please try following link to check if you can download: https://download.microsoft.com/download/D/B/D/DBDECC99-4DCA-4674-983A-CC1ABABA2B37/SSMAforAccess_7.8.0.msi


    Hope it can help you .


    Best Regards,


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Proposed as answer by Mbala_up Wednesday, November 7, 2018 8:37 AM
    • Marked as answer by KaseyD Thursday, November 8, 2018 12:53 AM
    Tuesday, November 6, 2018 8:01 AM
  • Rachel,

    Thank you so very much, I was able to download version 7.8 and get it installed. I can now migrate Access databases over to SQL Server 2008.

    Thank you again for your time,


    Thursday, November 8, 2018 12:54 AM
  • Hi Rachel, 

    i am looking for SSMAfor Access 7.11 32-bit version. Can you post the direct link.



    Thursday, February 28, 2019 8:35 PM