Upsizing MS Access to Sql Server RRS feed

  • Question

  • Hi I want to upsize a 100 MB Ms Acceess (2010) database to Sql server. Is the Sql Server express version the right choice? And what is the latest vesrion? The client has already Sql Server 2012 but they stricted me not to choose it because they use it for your ERP and very often they have problems and restart it.
    • Edited by nonlinearly Tuesday, July 16, 2019 12:26 PM
    Tuesday, July 16, 2019 12:25 PM


  • Yes, Express can utilize max. 1 GB Memory, but your 100 MB database will fit completly into it and SQL Server can manage Memory much better then MS Access.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, July 16, 2019 1:59 PM

All replies