Hi everyone,
I have some doubts about distributed partitioned views.
When we create a distributed partitioned view whcih include three server, do we have tocreate this same distributed partitioned view in that three server in order to make each server to see adn especially modify it ?
Thanks
Yes, you need to create the DPV on each server if you want to be able to modify the data on one or more of the servers from each one. Ex:
-- server1
create view dpv
as
select ... from dbo.tbl1
union all
select ... from server2.dbo.tbl2
union all
select ... from server3.dbo.tbl3
-- server2
create view dpv
as
select ... from server1.dbo.tbl1
union all
select ... from dbo.tbl2
union all
select ... from server3.dbo.tbl3
-- server3
create view dpv
as
select ... from server1.dbo.tbl1
union all
select ... from server2.dbo.tbl2
union all
select ... from dbo.tbl3
No comments:
Post a Comment