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.

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 Replicating Views

Author  Topic 

mrasmussen
Starting Member

1 Post

Posted - 2012-02-16 : 15:12:01
I have two views I need to replicate but the problem is these two views are created from five tables which are dependant on other tables. If I grab all dependencies I end up replicating gigs of data just for these two views.

My question is if I only replicate the data in the views, will that work? Do I have to replicate all dependencies?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-02-16 : 15:45:29
You would have to switch to an indexed view, but maybe I'm not understanding you right. If the view requires 5 tables, then why do you think you don't need those 5 tables?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-02-17 : 07:27:10
I think the OP means that the 5 required tables are dependant on still other tables. Don't know what that means unless it's foreign keys.

In that case, I'll just drop the FKs on the subscriber(s).
Go to Top of Page
   

- Advertisement -