Do .mdf file have versions? How can i know that? What precautions do we need to edit that with sql server?

[SanjoyNath]

Dear Experts,

Do .mdf file have versions? How can i know that? What precautions do we need to edit that with sql server?

For Different purpose of ERP in our office , we have different versions of database server engines of sql server. When we aattach the .mdf files in some of these servers (like version 2019) some Advance Steel works fine whereas some other advance steel installations cannot read the databases

What are the reasons with the .mdf files (kept with same names and with same path) still dont work for some (All  LAtest versions of Advance Steel)

[Paul_You_Mechwest]

Most of Advance Steel Version runs with SQL Server 2014. If mdf files are saved with higher version of SQL Server they cannot be read with normal installation.

[SanjoyNath]

Dear @Paul_You_Mechwest .

Dear Experts,

Is there any way to check the version of current active sql server running at the backend?

Is there any way to check the versions property of the .mdf files ?

Is there any way to understand the errors of management tools ior database conversions?

[Paul_You_Mechwest]

I normally check local SQL Server version from Task Manager.
You can see sqlserver.exe from Task manager if you run Advance Steel.
If file location is like below, SQL server 2014 is running.
C:\Program Files\Microsoft SQL Server\120\LocalDB\Binn

120 - SQL Server 2014
130 - SQL Server 2016

You can check database compatibility version from SQL Server Management Studio

I usually keep database in central location where file version history is available I am using Dropbox for now.
Database files are copied to local directory of staff's workstation before running Advance Steel.