transfer data from one database to another database

Question

Post reply

transfer data from one database to another database

gupta.sreekanth

SSC-Addicted

Points: 483
More actions
December 16, 2010 at 11:13 pm

#244484

hi,
can any one tell how to transfer data from a table in one database to another table in another database.....if any one knows....please write sample query for me.....

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 1

removed

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 2

gupta.sreekanth (12/16/2010)
hi,
can any one tell how to transfer data from a table in one database to another table in another database.....if any one knows....please write sample query for me.....

use SSIS package

or

Insert INTO DestinationDB..tblETC Select * from SourceDB..TblETC

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 3

Adding few more....

If the two databases are in different servers, use linked server.

Import/Export Wizard is another option.

Resender SSCertifiable Points: 7443 More actions · Answer 4

Easiest way is to simply write insert into table1 on target database select data from table1 on source database

Better would be use of SSIS packet