Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mohit16
Starting Member
4 Posts |
 Posted - 2010-07-19 : 07:10:15
|
| I have setup a 2node peer-to-peer transactional replication. It works fine ie, any changes made to the DB at Node A are replicated to Node B and vice versa. We have a requirement such that any updates made to Node A should be reflected in Node B but updates are not allowed in Node B(slave) server. Node B should have a materialized view of database objects in Node A.Please suggest a way to accomplish such a scenario in SQL server 2008.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mohit16
Starting Member
4 Posts |
Posted - 2010-07-20 : 01:49:49
|
| Well, I thought there might be a concept of Materialized view replication in SQL server as we have it in Oracle. Anyways, will go with your suggestion..thanx a lot tKizer.. :-) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Transactional Replication