November 2, 2004 at 5:51 am
Hi Andy, Thanks for the great articles on replication, I have read all 3.
My question relates to the following. in terms of admin overhead, snapshot seems the easiest in my situation as the subscriber database is read only and is updated on nightly as well on-demand by the power user at the subscriber site.
It is a reporting database so being a day behind is not a problem.
Bandwidth is, however, a problem so i will be selecting an alternate location and setting to use compressed snapshots. I want to use filters to make them even smaller.
My question is this. After the initial snapshot is moved via CD, If I setup horizontal filters this will reduce the snapshot file size (and it will also be compressed by the .cab faciity). The filter i will use will be something like Trx_Date >=now() - 60 days. Thus only transactions within the last 60days will be sent over. This is ok because transactions can only be added or edited within the last 60 days. To be 100% safe i will set the filter to 90 days prior.
I believe this solution is very close to a transactional replication and It will be simpler to maintain and since the subscriber is read only snapshot will be fine. I wanted to ask you if,
1) in your opinion, i was choosing the right replication type and;
2)did i grasp the similarities to transactional correctly?
With best regards,
Goldfinger
...My 1st post... so ettiquite suggestions most welcome.
Is the Fuel yummier than the Fisher?
December 19, 2004 at 1:07 pm
Sorry it took so for long the reply - damn day job!
Snapshot is the easiest conceptually and you're on target using a filter. As long as you can do the snapshot within the window you have and you don't exceed whatever bandwidth constraints you have (which is usually just measured in time anyway) then you're fine with this plan. An added advantage is that you're keeping the minimum data you need on the reporting server without having to manage any other steps. Snapshots also isolate you from having to manage table changes - they get sent over automatically by default with the next snapshot.
For a beginner, this is a good place to start. I'd recommend that once you have this going you try doing the same task with transactional - more powerful, but a more things to deal with.
Nothing wrong with the etiquette.
December 19, 2004 at 1:08 pm
Sorry it took so long to reply. In general I prefer readers to post to the forums only, I get a LOT of mail, sometimes between that and work in can take a while before I manage a response.
Hope you're enjoying the site and getting good answers!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply