Migrating from SQL 2005 to SQL 2008

[DiscipleDOC]

I have a project that I will be working on for the next several weeks. I'm about to buy a PowerEdge 310 and install SQL Server 2008 on the Win Serv 2K8.

I will need to migrate an already existing database to the new server.

I'm doing a lot of research on this, because I do not want any hidden caveats. This DB is proverbially the "meat and potatoes" of my company.

Any links/suggestions that you may have will be greatly appreciated.

[ViN86]

Shouldn't it be a simple Export/Import procedure?

Just don't take down your old one til you're sure your new one is up :lol:

Here's a nice link:
http://www.packtpub.com/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps

[DiscipleDOC]

Shouldn't it be a simple Export/Import procedure?

Just don't take down your old one til you're sure your new one is up :lol:

Here's a nice link:
http://www.packtpub.com/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps

Thanks....that is exactly what I need. ;)

[crainger]

You'll be k DOC.

[LovingSticky]

Simple Attach/Dettach is not enough. To use version 10 (SQLSRV 2008) functionality, you have to change Compatibility Level as well, in DB Properties/Options.