Are you migrating servers or upgrading? Either way, shouldn't be a problem. Backup and test <- the three most ass-saving words for a consultant.
http://blogs.msdn.com/b/blakhani/archive/2008/12/27/resources-migration-from-sql-2000-sql2005-to-sql-2008.aspx