is it possible to replicate a view from a SQL server to another one?

Question

I know a view is composed of tables. Can I replicate a view anyway?

score 6 · Accepted Answer · edited Mar 09 '13 at 00:16

6

For SQL SERVER 2008
Have a look at the link http://msdn.microsoft.com/en-us/library/ms152559.aspx. This explains all the objects that can be replicated.

edited Mar 09 '13 at 00:16

M.Babcock

answered Jul 10 '09 at 04:27

Atul

score 2 · Answer 2 · answered Jul 10 '09 at 03:32

2

Yes.

You would need to add the view to the Publication (along with the underlying tables)

answered Jul 10 '09 at 03:32

Mitch Wheat

score -1 · Answer 3 · answered Jul 10 '09 at 03:32

-1

What you want to do is replicate the table and create a view of the replicated table.

answered Jul 10 '09 at 03:32

MyItchyChin

4

While that is an option, you can also replicate just the view. See replicating "Indexed Views as Tables" in http://msdn.microsoft.com/en-us/library/ms152559.aspx – Jonathan Allen Feb 09 '12 at 22:16

3 Answers3