开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜