I suggest using the Upgrade Advisor from Microsoft.
As for moving the database take a look at this.
I suggest you do all this in a test environment first to work out any issues.
answered Jul 25, 2013 at 12:22 PM
I have always simply taken a full backup on SQL 2000, then restored that backup to SQL 2008 or 2008R2. No issues as of yet. You have to manually change the compatibility mode. I have come across a few deprecated commands in sprocs and views that had to be updated. Upgrade Advisor detected those for me.
Best advise I can give you is test then test again.
answered Jul 25, 2013 at 01:04 PM