January 20, 2009 at 9:23 am
Hi All,
I have setup Peer-to-Peer Replication in my prodcution envoirnment and it is running perfectly fine.
I want to know how can i replicate indexed views in peer-to-peer replication.
Your help or workaround to replicate tables having no primary key through P2P replication will be a great help to me.
January 20, 2009 at 9:39 am
raj (1/20/2009)
Your help or workaround to replicate tables having no primary key through P2P replication will be a great help to me.
IIRC, you either need a primary/unique key, or you are limited to Snapshot Replication.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 20, 2009 at 10:17 am
Is there a way to replicate indexed view articals in P2P replication as i have created unique key on it.
January 20, 2009 at 10:27 am
This earlier thread seems to have a way to do it: http://www.sqlservercentral.com/Forums/Topic348632-291-1.aspx#bm599356
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 20, 2009 at 12:28 pm
Thread will help in replicating Indexed views using Transactional Replication.
But i need help to replicate indexed views using Peer-to-Peer Replication.
January 21, 2009 at 12:35 am
Requesting all guru's to help me on my query.
January 21, 2009 at 6:09 am
I have never used peer-to-peer replication, so I cannot help you there.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 21, 2009 at 10:50 am
raj (1/21/2009)
Requesting all guru's to help me on my query.
Can you post the DDL of you Indexed View and the one of the underlying table ?
* Noel
January 22, 2009 at 4:49 am
I have created a simple view with schema binding and created a index on one of the view column having unique data.
Table is having few columns without any index or keys.
Sorry,I can't post the code here.
January 28, 2009 at 9:29 am
can anyone help me on my query.
January 28, 2009 at 12:53 pm
raj (1/28/2009)
can anyone help me on my query.
If you can't post DDL it will be hard to tell you what the problem is!
* Noel
January 29, 2009 at 8:10 pm
You cannot hide forever...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 30, 2009 at 10:53 am
Below is the test code:
CREATE VIEW SalesOrderDetialsViews WITH SCHEMABINDING AS
SELECT SalesOrderDetailID,ProductID,UnitPrice,count_big(*) as cnt from Sales.SalesOrderDetail
group by SalesOrderDetailID,ProductID,UnitPrice
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply