locked
Replicating Views In Transactional Replication RRS feed

  • Question

  • Two Questions on Transactional Replication

    1.All a view is a stored query. Is it better to script out and recreate all the views on the subscribing server on the replicated database or to replicate the views on to the subscriber, hence adding additional load.

     

    2.When replicating Views, is there a way to have them replicated to the views sub folder under the database ( to have all the articles placed in their own respective sub-folders on the subscriber database similar to the placement on publisher db)?

    Friday, July 23, 2010 3:04 PM

Answers

  • 1) the over head of replicating a view is minimal. I would replicate it.

    2) This is how it works by default. Do you see something different?


    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    • Proposed as answer by Tom Li - MSFT Tuesday, July 27, 2010 9:07 AM
    • Marked as answer by Tom Li - MSFT Sunday, August 1, 2010 9:28 AM
    Saturday, July 24, 2010 1:07 AM
    Answerer

All replies

  • 1) the over head of replicating a view is minimal. I would replicate it.

    2) This is how it works by default. Do you see something different?


    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    • Proposed as answer by Tom Li - MSFT Tuesday, July 27, 2010 9:07 AM
    • Marked as answer by Tom Li - MSFT Sunday, August 1, 2010 9:28 AM
    Saturday, July 24, 2010 1:07 AM
    Answerer
  • 1. If you have made your view for some kind of security it would be logic to replicate te views otherwise I would script out an recreate

    2. No you cannot. What you can do is use another schema (other than DBO) or use something like a prefix in the name.

    • Proposed as answer by Tom Li - MSFT Tuesday, July 27, 2010 9:08 AM
    Saturday, July 24, 2010 8:50 PM
  • 1. yes, the over head is minimal.

     

    2. It would be preferable, just from the perspective of having the different articles such as tables, views, etc in their own respective sub folders on the subscriber. Functionally, its the same, however, having over N number of tables and an additional M number of views together in the same folder makes it very crowded. 

     

    Thanks Hilary and Ruud, that helps.

    • Proposed as answer by Tom Li - MSFT Tuesday, July 27, 2010 9:08 AM
    Saturday, July 24, 2010 10:19 PM