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

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,

-Kasey

Answer 1

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,

Rachel

---

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 [e-mail].

Answer 2

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,

-Kasey

Answer 3

Hi Rachel, 

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

Thanks,

Venkat