DB to DB - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

DB to DB

Author

Topic

davbrew2005
Starting Member

1 Post

Posted - 2006-03-15 : 12:14:58

I have two databases on the same sql server. I need to take data from one and put into the other. This will happen from time to time. What is the best way?

Nitu
Yak Posting Veteran

81 Posts

Posted - 2006-03-15 : 12:27:25

You can use DTS to transfer data from one DB to another DB and schedule it to run from time to time.

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-03-15 : 12:33:12

or u may use
-- Import export wizard
-- replication

kid_on_the_block
Posting Yak Master

172 Posts

Posted - 2006-03-16 : 06:52:25

It all depends upon the frequency it happens & how soon do you want to see the data in the second DB ...

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-03-16 : 06:55:24

you can also do this

insert into db1.dbo.table1(col1, col2, col3)
select col1, col2, col3
from   db2.dbo.table2

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources