How do you migrate SQL Server 2005 databases to SQL Server 2008?
Is it as easy as backing up 2005 databases and simply restore in 2008?
Are there any compatibility issues?
Is SQL Server Reporting service changed in anyway?
How would you go about upgrading SQL server?
Best Answer
It's easier. Run the install for SQL Server 2008 on your server, choose the upgrade option. Done.
Takes maybe 15 minutes, give or take. It really is remarkably easy.
Edit: You still want to do a backup anyway right before upgrading, just in case. But more than likely you won't need it.