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

  • Publisher has to be higher or equal version than subscriber in order to be supported. SQL Server 7.0 is totally not supported. So you are on your own. I guess, your as is implementation of bcp out and bcp in data is the way or look for a 3rd party who still supports this. – Kin Shah Nov 17 '16 at 15:37

You can find a lot of articles about MS-SQL Server 7.0 replication in Technet and MSDN.

Two-Way Replication with SQL Server 7.0

Microsoft SQL Server 7.0 Replication Made Easy

Replication for Microsoft SQL Server Version 7.0

| improve this answer | |

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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.