datatransfer

microsoft.public.sqlserver.tools

20 Jun 2006 4:13 PM

shif

hi
I have 2 databses db1,db2.I want to transfer data from db1.table to
db2.table.without using export data method through procedure or sql stmt how
can i do it.please help

--
Thanks

20 Jun 2006 4:55 PM

Greg Larsen

You should be able to code and insert statement similar to the one below:

insert into db2.dbo.table select * from db1.dbo.table

Show quote

"shif" wrote:

> hi
> I have 2 databses db1,db2.I want to transfer data from db1.table to
> db2.table.without using export data method through procedure or sql stmt how
> can i do it.please help
> --
> Thanks