In addition to other solutions you can deploy your DB files to destination system and commit an attach action :
First detach old one :
use master
go
sp_detach_db 'olddb'
go
Then attach new one :
use master
go
sp_attach_db 'mydb','E:\Sqldata\mydbdata.mdf','E:\Sqldata\mydblog.ldf'
go
read more at:
http://support.microsoft.com/kb/224071[
^]
and another way is complete restore if the previous data is not important for you :
RESTORE DATABASE AdventureWorks
FROM DISK = 'Z:\SQLServerBackups\AdventureWorks.bak'
read more :
http://msdn.microsoft.com/en-us/library/ms186858%28v=sql.90%29.aspx[
^]
Both of these methods are suitable for the condition that you don't need existing data. But if you want preserve existing data it needs a deep observation of the database and applying needed changes which would be probably very complicated...