Today, we found the SQL Server Database Copy Tool project on codeplex when googling. It is a nice tool for to copy databases from one SQL Server to another.

Copies a sql server database from one server to another by backing it up, copying the backup file to the destination server and restoring the database.

Please go and download via following link if you are interested.