Converting a SQL Server 2000 file to 2012

As the title says, unfortunately it seems that there is not direct upgrade path.

I no longer have a copy of SQL Server 2000 or 2005  to convert the file :(

Is there any open source tool that could help ?

Any ideas ?

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

PadawanDBAOperational DBACommented:
To be honest, it's probably going to be easiest to just get the trial version of SQL Server 2008 R2, restore there, take a backup from there and then restore on 2012.

edit:  unless, of course, you are lucky enough to have one of the 2 versions with no upgrade path via a 2008/2008r2 instance (

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
DodsworthAuthor Commented:
oh so I don't need 2000 to start the process ?
DodsworthAuthor Commented:
Ok got it loaded into 2008 and backed it up but it doesn't appear in 2012 ?
PadawanDBAOperational DBACommented:
When you say it doesn't appear in 2012, how do you mean?  As in you can't see the .bak backup file from 2012 when you try to restore it?
DodsworthAuthor Commented:
I managed it using attach after changing the Compatibility Level in R2.
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

From novice to tech pro — start learning today.