We have SQL 2000 at our office and SQL 2008 at a data center. The sites are connected via a VPN between two PIX firewalls.
I have one database that needs to be shared between the two. The users at the office insert the records and users on a web application hosted at the data center update the records. The updated records need to go back to the office server which uses them to update a seperate database that is only used locally at the office.
Is this a situation for merge replication or bidirectional transactional replication? Is bidirectional transactional replication even possible with a mix of SQL 2000 and SQL 2008? Am I overlooking a different solution?