All geek questions in one place

With a SQL Server 2005 database that is configured as a Push Replication Replication subscriber, can I use the same database as Publisher?

We have Merge (Push) replication configured between databases in our different offices. Each database contains a complete set of data, so users in each office only need to connect to the database server in their office. When users want to leave the site, they need to pull a subset of the data into the local (on the user's laptop) SQL Express database. Can SQL Server 2005 replication be used to pull this subset from one of the subscriber databases, and then redo their local changes?

Change . We do not want users of regional offices to replicate our main publisher database, but with respect to subscriber databases. Therefore, each Subscriber should act as a publisher for users of this office (possibly even using transactional replication instead of merge replication)

+3
source share
1 answer

Yes, but make third-party SQL Server 2005 Express Edition a merge replication subscriber (i.e. pointing to your distributor).

Link .

+1
source

Source: https://habr.com/ru/post/1704201/

More articles:


All Articles