Windows Need advice on moving ancient MSSQL db to new server

Don't really have any experience with MSSQL, so I'm a bit confused at the moment (wooot, no mssqldump command?!)

I need to move a database from an ancient server running MSSQL 8.0 (SQL Server 2000) to another one running version 11.0 (SQL server 2012). Both servers are the free Express edition.

In an ideal world I'd shut down the running SQL, copy over the .mdf file and use a magic Import button in a configuration interface on the new server.

So please tell me how wrong I am and how the world is far from perfect...
Anyone has some experience with this?

 

You can't step it up that many versions in one clean sweep, you'll need to make an incremental change to 2005/2008., technet blogs are pretty handy for this:
http://blogs.technet.com/b/mdegre/a...ation-sql-server-2000-to-sql-server-2012.aspx