Sorry - I wasn't clear. I just want to know if we could use Sql Server
indexed view to move data - kind of replication-like - from one Sql Server to
another. In other words as data is modified in the underlying table, it
would be placed into the view and I'm wondering if that view can be on
another server.
[quoted text, click to view] "Uri Dimant" wrote:
> CLM
> I do not know how Materialzied Views works/designed in Oracle. We use an
> indexed views in SQL Server to improve perfomance of reports (ie SELECT
> ageragates). I do not think that using an indexed views to move data will
> speed up the queries. Can you create a linked server to oracle database?
>
>
>
>
>
>
> "CLM" <CLM@discussions.microsoft.com> wrote in message
> news:D0E7FEE2-4047-4026-87BB-2DEDA0E60F61@microsoft.com...
> > At my last place, they were about to use Oracle Materialzied Views to move
> > data from a server in Europe to our servers in the US. If you want to use
> > Materialized or Indexed Views in 2000 or 2005, could you do it with this
> > same
> > goal? That is, could you use an Indexed view to push data to another
> > server
> > either in the same location or even a remote location? If so, are there
> > any
> > links/recommendations/best practices associated with this?
>
>
This was more of a curiosity question. I thought maybe this was designed to
be a data movement tool as well and I just hadn't read about it.
Thx for the info.
[quoted text, click to view] "Andrew J. Kelly" wrote:
> No that the underlying data for the indexed view needs to be in the same
> database as the view was defined. Why not just use replication as that is
> what it was designed for.
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
>
> "CLM" <CLM@discussions.microsoft.com> wrote in message
> news:E662C7BA-F870-4F1B-8989-2ACF3B9FB9AB@microsoft.com...
> > Sorry - I wasn't clear. I just want to know if we could use Sql Server
> > indexed view to move data - kind of replication-like - from one Sql Server
> > to
> > another. In other words as data is modified in the underlying table, it
> > would be placed into the view and I'm wondering if that view can be on
> > another server.
> >
> > "Uri Dimant" wrote:
> >
> >> CLM
> >> I do not know how Materialzied Views works/designed in Oracle. We use an
> >> indexed views in SQL Server to improve perfomance of reports (ie SELECT
> >> ageragates). I do not think that using an indexed views to move data will
> >> speed up the queries. Can you create a linked server to oracle database?
> >>
> >>
> >>
> >>
> >>
> >>
> >> "CLM" <CLM@discussions.microsoft.com> wrote in message
> >> news:D0E7FEE2-4047-4026-87BB-2DEDA0E60F61@microsoft.com...
> >> > At my last place, they were about to use Oracle Materialzied Views to
> >> > move
> >> > data from a server in Europe to our servers in the US. If you want to
> >> > use
> >> > Materialized or Indexed Views in 2000 or 2005, could you do it with
> >> > this
> >> > same
> >> > goal? That is, could you use an Indexed view to push data to another
> >> > server
> >> > either in the same location or even a remote location? If so, are
> >> > there
> >> > any
> >> > links/recommendations/best practices associated with this?
> >>
> >>
> >>
>
No that the underlying data for the indexed view needs to be in the same
database as the view was defined. Why not just use replication as that is
what it was designed for.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
[quoted text, click to view] "CLM" <CLM@discussions.microsoft.com> wrote in message
news:E662C7BA-F870-4F1B-8989-2ACF3B9FB9AB@microsoft.com...
> Sorry - I wasn't clear. I just want to know if we could use Sql Server
> indexed view to move data - kind of replication-like - from one Sql Server
> to
> another. In other words as data is modified in the underlying table, it
> would be placed into the view and I'm wondering if that view can be on
> another server.
>
> "Uri Dimant" wrote:
>
>> CLM
>> I do not know how Materialzied Views works/designed in Oracle. We use an
>> indexed views in SQL Server to improve perfomance of reports (ie SELECT
>> ageragates). I do not think that using an indexed views to move data will
>> speed up the queries. Can you create a linked server to oracle database?
>>
>>
>>
>>
>>
>>
>> "CLM" <CLM@discussions.microsoft.com> wrote in message
>> news:D0E7FEE2-4047-4026-87BB-2DEDA0E60F61@microsoft.com...
>> > At my last place, they were about to use Oracle Materialzied Views to
>> > move
>> > data from a server in Europe to our servers in the US. If you want to
>> > use
>> > Materialized or Indexed Views in 2000 or 2005, could you do it with
>> > this
>> > same
>> > goal? That is, could you use an Indexed view to push data to another
>> > server
>> > either in the same location or even a remote location? If so, are
>> > there
>> > any
>> > links/recommendations/best practices associated with this?
>>
>>
>>
Don't see what you're looking for? Try a search.
