是否可以将视图从SQL服务器复制到另一个?

时间:2022-05-19 07:32:53

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.

您要做的是复制表并创建复制表的视图。