Posted by Damien on 04/18/07 14:13

On Apr 18, 12:24 am, Anthony Paul <anthonypa...@gmail.com> wrote:
> Hello Paul,
>
> On Apr 17, 6:26 pm, "Paul Ibison" <Paul.Ibi...@Pygmalion.Com> wrote:
>
> > Have a look at Hilary's book for snapshot and transactional, but if you're
> > after more merge info and don't like the Pro book then it's really BOL that
> > you need and then doing some scenarios for yourself to gain experience. As
> > for websites, I have some useful info on the site below and there are other
> > articles out on the various SQL Server sites you can get by googling, but
> > nothing I think specific to your requirements.
>
> Will do.
>
> > BTW this doesn't really lend itself to modifying the filters dynamically. At
> > least this is not as straightforward as you might think. Normally the
> > partitions are well designed to start with. If you want something more
> > dynamic, then I'd not filter at all in replication and I'd use filters on
> > the client application instead.
> > Cheers,
> > Paul Ibison SQL Server MVP,www.replicationanswers.com
>
> Ahhh.... then that's a problem, I'd definitely need the ability to be
> able to programatically and dynamically change the filtering criteria
> as the need arises, in this case every time a new report is requested
> that needs a subset of data not being captured by the replication
> process. You would think that this is such a common scenario... Also,
> filtering on the client side is not an option either since that would
> mean that all of the data would get replicated to the reporting db. I
> could have sworn that I read in msdn that the filters could be changed
> via stored procs though... I'll have to look that up.
>
> Thanks for your help Paul!
>
> Anthony

This may sound like a stupid question, but are you sure replicating
the whole database isn't an option? I know you've described the
database as huge, but one mans huge is another mans insignificant (or
the other way around).

It just sounds like you're putting in a lot of work when you may be
able to keep it simple. Apologies if this is a path you've already
worn smooth, just wondering what has made you sure that bog standard
replication isn't the way to go.

Damien

[Back to original message]