SQL Server 2005 Express to SQL Server 2014 Express migration

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.
markremmsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Lee SavidgeCommented:
Use backup and Restore rather than Detach and Reattach. That should be fine unless you have SQL logins attached to it. If you restore, make sure you check the compatibility level. You can leave it at 2005 or up it to 2014 and then do a full retest.
markremmsAuthor Commented:
I have also tried to restore from a backup into 2015 with the following result:
SQL Server Error message
markremmsAuthor Commented:
Hi Lee

Thanks for that.

So is my problem probably caused because the backup was done when there was a SQL login active?
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

Lee SavidgeCommented:
Well, error 5 is a permissions error. Try restoring to a folder outside of Program Files (x86), say c:\TempRestore or something, jsut to rule that out. I've seen the "Access is denied" a few times when it has nothing to do with permissions but you need to rule it out.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
markremmsAuthor Commented:
That works fine - thank you.
Lee SavidgeCommented:
Glad I could help :)

Thanks.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.