Re: SQL 2000 <-> SQL 2005

Terry,

answers inline....

I have a situation where I need to sync data over a VPN (T-1 connectivity)
on a semi-realtime basis. This data is not highly dynamic, at most a few
thousand rows change per day.

I have SQL 2000 on one end and SQL 2005 on the other. Can 2000 and 2005
work together?

Yes

What is the best replication type for close to real time synchronization,
is it 'Merge'?

Can data be changed on each end? If so, can it conflict? If data flows in
one direction only, I would use transactional, which is also generally much
faster.

Can syncs be manually initialized in the prescribed type?
Yes - by a variety of means - programatically, windows sync manager,
starting a job or using replication monitor.


Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .


.