November 13, 2007 at 2:49 pm
Hi,
We currently have replication set up and running between SQL server 2000 and about 15 laptops with MSDE replicated database. The laptops are not always connected to the network. We have both transactional and merge replication using pull subscriptions. We basically have a star configuration with the SQL server 2000 as the central point and the laptops with different applications and databases syncing with the SQL server. It works fine except that the central SQL server does not have the control of the synchronization jobs and if we want to change anything about subscription we have to get the laptops in and configure the subscription on the laptops.
I know push subscription is good for a small number of subscribers and have the central control but may overload the SQL server. My question is what's the definition of 'a small number'. In our case, the numbers of updates on the laptops are usually pretty small -- like a dozen of updates on average -- so during synchronization only a small amount of data is moved across the network for each laptop. So considering all this, is 15 a small number for a push subscription implementation? We don't want to overload the SQL server but would want to have the central control. I looked into Remote Agent Activation. Is that the way to go? With Remote Agent Activation, the central server still has the total control of all the synchronization jobs and can see all the job history, correct?
Thanks in advance for any advice.
November 14, 2007 at 5:53 pm
I found that the Remote Agent Activation can not be done on MSDE. It can only be activated on SQL server 2000.
So here is another question. When pull subscriptions are used on each of the laptops, and the laptops only connect to the network occasionally, is there a way that the distributor know which laptops have synced their data and which ones have not? In the Distribution database the MSrepl_transactions table will hold the transactions until all the subscribers synced. But how would we know which ones synced which ones has not?
Thanks.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply