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
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