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.