What MSSQL versions do AccessData products support?

AccessData 7.5 and newer products: 

  • MSSQL 2016
  • MSSQL 2017
  • MSSQL 2019


AccessData 7.3-7.4 products: 

  • MSSQL 2012
  • MSSQL 2014
  • MSSQL 2016
  • MSSQL 2017
  • MSSQL 2019


AccessData 7.0-7.2 products: 

  • MSSQL 2012
  • MSSQL 2014
  • MSSQL 2016
  • MSSQL 2017


AccessData 6.x products:

  • MSSQL 2008 R2
  • MSSQL 2012
  • MSSQL 2014


Why don't AccessData 7.x products support MSSQL 2008 R2?

AccessData added support for using MSSQL's internal sequences as of their 7.0 product release.  MSSQL first implemented internal sequence in version 2012.

 

How can I upgrade to a 7.x product if I'm currently running MSSQL 2008 R2?

Before upgrading to an AccessData 7.x release, you will need to upgrade to MSSQL 2012 or 2014.

 

Can I migrate and/or upgrade my AccessData database straight from MSSQL 2008 R2 to 2016/2017/2019?

No.  Since 6.x products do not support MSSQL 2016/2017/2019, and 7.x products don't support MSSQL 2008 R2, you will need to first go to MSSQL 2012 or 2014 in order to upgrade the AccessData database to 7.x.  After upgrading the AccessData database, you can then upgrade MSSQL to 2016/2017/2019, if desired.