SQL Server 2005 to 2008 upgrade - are MDF files binary compatible?
- by james
I have 50 databases on a MS SQL Server 2005 system and want to upgrade to MS SQL Server 2008.
This is what I tried on some test machines:
1. copied the \DATA directory from the source (MSSQL 2005) to exactly the same path on the target (MSSQL 2008) server.
2. edited the startup parameters on the MSSQL 2008 service to point to the path of the MSSQL…