Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

export data from physical svr 1 to phys. svr 2?

Status
Not open for further replies.
jlsmithhartfiel

jlsmithhartfiel

Programmer
Jan 7, 2002
336
US
Hi!

Here's the setup:
Physical webserver1 running SQL server "A"; db1
Physical webserver2 running SQL server "B"; db2

They are networked together.

I need to create a DTS package that will copy a table from db1 to db2.

I know how to do it if the dbs were both in the same SQL server; and also if on the same machine but separate SQL servers.

Just not sure how to do it with separate physical webservers. This is for a client, and unfortunately I don't have a 2 webservers to test on here.

Thanks in advance!
Jessica Jessica [ponytails2]
 
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
581
bharons
bharons
coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
894
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
558
grnzbra
grnzbra
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Seconds to minutes 2
Replies
5
Views
1K
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top