Last post Apr 13, 2017 02:52 AM by kaushalparik27
Apr 12, 2017 02:09 PM|oned_gk|LINK
I have a couple mdf and ldf file, i don't know what version is it.
I try to create connection but the sql version not compatible with the LocalDb instance, then I try to attacth to my sql server and doesn't work.
Is there any tool or quick way to determine what sql version?
Apr 12, 2017 02:27 PM|kaushalparik27|LINK
PS C:\Users\KAUSHAL> get-content -Encoding Byte "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\NORTHWND.mdf" | select-object -skip 0x12064 -first 21942PS C:\Users\KAUSHAL> 2*256+194706
(bold marked is output) 706 - that is SQL Server 2012.
How to determine the database version of an MDF file
Apr 12, 2017 09:43 PM|oned_gk|LINK
Apologize for late reply, i just wake up and do some try.
I try to make connection using (LocalDB)\MSSQLLocalDB from VS to the file and not work.
Then I try to use Management Studio, connect to (LocalDB)\MSSQLLocalDB instance
I don't believe it, I can attacth the file from Management Studio and work with the file
I still don't know what the exact version, but from database properties it say compatible with sql 2008(100)
If i can attach all previous version from management studio, i think i don't need the tool anymore.
My question now, if I can attach older sql file to from Management Studio
So, what connectionstring to connect older sql file (without knowing sql version)?
Apr 13, 2017 02:52 AM|kaushalparik27|LINK