Current database is live and used for an office and linked to a website. It's in SQL Server 2005 Express.
Aim is to migrate to SQL Server 2014 Express however during the redevelopment of the website there is a desire to leave the old database in place.
So in my test environment I have installed both the 2005 and 2014 SQL Server Express versions and I have restored the database from a backup file into the 2005 instance.
I create a copy of the original database and then detach it from the 2005 instance aiming to attach it to the 2014 instance but when I attempt to browse to the attached database in Management Studio nothing is shown in the file browser.
I have verified that the files are there - they are just not visible. I have attempted to copy the files to a new location but Windows (7) will not allow me to as the file is "in use".
Seems to me that this must be a permissions issue related to the MS SQL Server user logged into the Management Studio but I don't know how to resolve it.