This is the scenario:
- 1 x SQL Server 2000 database running at remote site (Publisher)
- Website running at a different site requires mostly read and some write access (<5 tables) to the database
- Cross Network bandwidth utilization must be kept to a minimum
We would like to use SQL Server replication for this, with a subscriber at the location as the web server. Is merge replication the most appropriate replication type for this?
I did consider Transactional Replication with Updating subscriptions but according to technet, this is being discontinued in the next release of SQL Server.
We would like the replication to happen as real time as possible but network utilization is a consideration.