Backup and Restore Attach and Detach SSIS or DTS to transfer data after creating the database using scripts. But it purely depends on the ways you want to achieve, say downtime and by all means take help from Upgrade Advisor and from thsi http://sqlserver-qa.net/blogs/tools/archive/tags/upgrade/default...