开发者

Deploying CLR UDFs to SQL Server 2008 in a replicated environment?

开发者 https://www.devze.com 2023-02-20 15:05 出处:网络
I am running SQL Server 2008 with replication enabled.I have a .NET CLR database project with UDFs that I would like to deploy to SQL Server, however the objects are marked for replication.What\'s the

I am running SQL Server 2008 with replication enabled. I have a .NET CLR database project with UDFs that I would like to deploy to SQL Server, however the objects are marked for replication. What's the preferred way to deploy in this scenario? Do I need to r开发者_JAVA百科un a script before deployment that unmarks these for replication and then remarks them after deployment? Does that force me to recreate a new snapshot? Can I run these scripts automatically in Visual Studio as part of the deployment process?


You'll have to mark them as not replicated, deploy and then remark them as replicated.

Your current snapshot won't be valid so you'll have to generate a new one, but you can wait the That's what we do and I don't see how you can do otherwise.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号