Filtering suggestion
Brian Donahue
Posts: 6,590 Bronze 1
Hi Paul,
Thanks! We are looking into that.
Regards,
Brian Donahue
Red Gate Technical Support
"Paul Buxton" <psb@NOSPAMspireite.demon.co.uk> wrote in message
news:8o9vd36l0nl0$.9pafshlv0x8r.dlg@40tude.net...
> Hi,
>
> Is it possible for you to be able to add some row filtering functionality
> to Data Compare? I can't seem to find anything like this presently in the
> product.
>
> Specifically, we have a database that is a subset of the data in another
> database....for example, there is some data that is excluded in this
subset
> database if the datestamp is before the year 1995.
>
> It would be great is I could tell the comparison engine to filter the
> source database only much like the row filters you'd set up in SQLs
> Replication. It would help us in particular immensely.
>
> Presently, I have to have SQL snapshot with the filters, then I compare
the
> snapshot with my subset database.
>
>
> Cheers,
> Paul
Thanks! We are looking into that.
Regards,
Brian Donahue
Red Gate Technical Support
"Paul Buxton" <psb@NOSPAMspireite.demon.co.uk> wrote in message
news:8o9vd36l0nl0$.9pafshlv0x8r.dlg@40tude.net...
> Hi,
>
> Is it possible for you to be able to add some row filtering functionality
> to Data Compare? I can't seem to find anything like this presently in the
> product.
>
> Specifically, we have a database that is a subset of the data in another
> database....for example, there is some data that is excluded in this
subset
> database if the datestamp is before the year 1995.
>
> It would be great is I could tell the comparison engine to filter the
> source database only much like the row filters you'd set up in SQLs
> Replication. It would help us in particular immensely.
>
> Presently, I have to have SQL snapshot with the filters, then I compare
the
> snapshot with my subset database.
>
>
> Cheers,
> Paul
This discussion has been closed.
Comments
I failed to mention that you can compare indexed views in Data Compare
now, so it's possible to create a pair of indexed views in your databases
and effectively compare a subset of data through those.
Regards,
Brian Donahue
Red Gate Technical Support
"Martin Massé" <martin.masse@NOSPAMfacturation.net> wrote in message
news:YFQuGPxREHA.3156@server53...
> I was about to post a suggestion on the same issue. This functionnality
> would be VERY helpful.
>
> Thanks,
>
> "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
> news:%23WZIFAULEHA.2488@server53...
> > Hi Paul,
> >
> > Thanks! We are looking into that.
> >
> > Regards,
> >
> > Brian Donahue
> > Red Gate Technical Support
> >
> > "Paul Buxton" <psb@NOSPAMspireite.demon.co.uk> wrote in message
> > news:8o9vd36l0nl0$.9pafshlv0x8r.dlg@40tude.net...
> > > Hi,
> > >
> > > Is it possible for you to be able to add some row filtering
> functionality
> > > to Data Compare? I can't seem to find anything like this presently in
> the
> > > product.
> > >
> > > Specifically, we have a database that is a subset of the data in
another
> > > database....for example, there is some data that is excluded in this
> > subset
> > > database if the datestamp is before the year 1995.
> > >
> > > It would be great is I could tell the comparison engine to filter the
> > > source database only much like the row filters you'd set up in SQLs
> > > Replication. It would help us in particular immensely.
> > >
> > > Presently, I have to have SQL snapshot with the filters, then I
compare
> > the
> > > snapshot with my subset database.
> > >
> > >
> > > Cheers,
> > > Paul
> >
> >
>
>