So I have a SQL Server 7.0 database that can not be upgraded. it is only allowed to have data read and written in it. I created a SQL Server 2008 R2 database which is the same structure. I want to synchronize the data between both so whatever happens on the SS7.0 happens in the SS2008 R2, and vice versa, is there a way to do so? I'm not asking for a ready answer, I just want a trail to follow, tips and such. So far I only managed to export a copy of the data with bcp, but I can't do it each time
I would 'start' by doing some Internet searches for 'sql server 7 transactional replication'
This article appears to have quite a bit of useful information about this topic, but I'm not 100% sure if everything in the article is still relevant.