Migrating from SQL 2005 to SQL 2008
 

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.

Re: Migrating from SQL 2005 to SQL 2008
 

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/movi...in-three-steps

Re: Migrating from SQL 2005 to SQL 2008
 

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

Re: Migrating from SQL 2005 to SQL 2008
 

You'll be k DOC.

Re: Migrating from SQL 2005 to SQL 2008
 

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.