The options of transfer database between two database 1

[wg26]

Hi Everyone:

I have two exact the same databases in the same server with different names, Now I want to transfer one table's data from one database to the other. I know I can use dts to do the data transfer. But I want to know what other options I have to transfer these data? Can it be done by using T_SQL?
This table has no any relationship with other tables in the database. Can anyone please give me some suggestions? Thanks alot

 

[ClaireHCM]

sp_configure 'allow updates',1
RECONFIGURE WITH OVERRIDE

sp_dboption 'select into/bulkcopy','true'

select * into DB2..table1 from DB1..Table1

sp_dboption 'select into/bulkcopy','false'

sp_configure 'allow updates',0
RECONFIGURE WITH OVERRIDE