I know a view is composed of tables. Can I replicate a view anyway?
我知道一个视图由表组成。我还能复制一个视图吗?
3 个解决方案
#1
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.
对于SQL SERVER 2008,请查看链接http://msdn.microsoft.com/en-us/library/ms152559.aspx。这解释了可以复制的所有对象。
For SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms152559(SQL.90).aspx
对于SQL Server 2005 http://msdn.microsoft.com/en-us/library/ms152559(SQL.90).aspx
#2
1
Yes.
是。
You would need to add the view to the Publication (along with the underlying tables)
您需要将视图添加到发布(以及基础表)
#3
0
What you want to do is replicate the table and create a view of the replicated table.
您要做的是复制表并创建复制表的视图。
#1
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.
对于SQL SERVER 2008,请查看链接http://msdn.microsoft.com/en-us/library/ms152559.aspx。这解释了可以复制的所有对象。
For SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms152559(SQL.90).aspx
对于SQL Server 2005 http://msdn.microsoft.com/en-us/library/ms152559(SQL.90).aspx
#2
1
Yes.
是。
You would need to add the view to the Publication (along with the underlying tables)
您需要将视图添加到发布(以及基础表)
#3
0
What you want to do is replicate the table and create a view of the replicated table.
您要做的是复制表并创建复制表的视图。