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!

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

Using Replication or use DTS to copy data between 3 or more srvs

Status
Not open for further replies.

y3by

Programmer
Jan 15, 2002
92
0
0
PT
Hi ppl,
i'm developing a software that uses sqlsrv2k as d.b.
we have a srv in our w2k network and some others in some workgroups connected through a VPN, and others connect by modem.

i want to have the information on each d.b to be the same.
i thought of 2 things, REPLICATION or programing DTS to do it..
i think that replication is the correct way, but how can i ensure that the information in my office is CORRECTLY replicated through all servers, the vpn ones and de modem ones.

Is there any thing i need to check, to know if that is the correct choice!?

or else do i need to restruct my d.b to do it by using DTS !?!

can someone point me the way!?
thks in adv
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top