用户定义的函数在Visual Studio的早期版本中编码并在Sql Server 2008中使用;试图迁移到VS 2017 [英] User Defined Functions coded in a previous release of Visual Studio and used in Sql Server 2008; trying to migrate to VS 2017

问题描述

Alert
me

解决方案

Hi
Brian，

欢迎来到MSDN论坛。

请参阅您的描述，似乎您的问题是关于SQL CLR数据库项目开发，请参考：

如何：使用公共语言运行时集成创建和运行SQL Server用户定义函数
 

经过研究，我发现使用SSDT对CLR数据库对象有一些变化，请查看这个doc：
如何：使用CLR数据库对象

>>要使用SQL Server数据工具创建CLR数据库对象，您需要创建一个数据库项目，然后向其添加
CLR数据库对象。与以前版本的Visual Studio不同，您不需要创建单独的CLR项目，然后从数据库项目添加对它的引用。当您构建和发布数据库项目时，您将同时在项目中自动发布
CLR对象。您发布这些CLR对象，它们可以像任何其他数据库对象一样被调用和执行。

希望以上信息对您的问题有所帮助，因为我们的论坛是讨论VS IDE，对于更专业的
支持，请重定向到这个适当的论坛：
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ home？forum = ssdt 寻求更专业的支持，谢谢你的理解。

最好的问候，

萨拉

Alert me

解决方案

Hi Brian,

Welcome to the MSDN forum.

Refer to your description, it seems your issue is about the SQL CLR database project development, refer to this: How to: Create and Run a SQL Server User-Defined Function by using Common Language Run-time Integration  

After research, I found there have some changes about CLR database object using SSDT, please check this doc: How to: Work with CLR Database Objects

>> To create a CLR database object using SQL Server Data Tools, you create a database project and then add a CLR database object to it. Unlike in previous versions of Visual Studio, you do not need to create a separate CLR project and then add a reference to it from the database project. When you build and publish the database project, you automatically publish the CLR objects in the project at the same time. After you publish these CLR objects, they can be called and executed like any other database objects.

Hope the above information is helpful for your question and since our forum is to discuss the VS IDE, for a more professional support, please redirect to this appropriate forum: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=ssdt to seek for a more professional support, thank you for your understanding.

Best regards,

Sara

这篇关于用户定义的函数在Visual Studio的早期版本中编码并在Sql Server 2008中使用;试图迁移到VS 2017的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！