We release our database as a
.MDF file taken from a SQL Server 2008 R2 server. I have a client who is planning to move to SQL Server 2016 on a Windows OS 2016 and is asking if our
.MDF can be restored as a database on their SQL Server 2016 and will it work with Windows OS 2016.
I know that SQL Server 2016's lowest compatibility mode is 100 which is SQL Server 2008 but will it work on Windows OS 2016?
This article makes me feel that it wont https://www.sqlskills.com/blogs/glenn/operating-system-support-for-sql-server-versions/