SQL Server copy data from one database to another

Question

I need to copy the data from one database to another another, is there any accomplish this objective ?

Source is SQL Server 2005 and database name is SALES and I want to transfer that to SQL Server 2008 but a database name is CRM

Answer 1

IF THE TOW DATABASE IS THE SAME STRUCTURE MAKE eXPORT FROM THE SOURCE THEN MAKE IMPORT TO THE SQL SERVER 2008

Answer 2

There are different method for data transfer.
1) Export /Import
2)SSIS
3) linked server