我可以像在生产服务器中编译的代码一样在sql server中部署dll吗？ [英] Can I deploy the dll in sql server like a code compiled dll in production server?

问题描述

我如何在生产服务器中像编译后的dll一样在sql server中部署dll？



谢谢，

Hi,

How can I deploy the dll in sql server like a compiled dll in production server?

Thanks,

推荐答案

不，你不能这样做。 dll的目的与sql脚本完全不同。您需要正确理解这些术语。

dll是Microsoft实现的共享库概念，可用作项目的库。虽然SQL Server中的数据驻留在.mdf文件中，并且没有dll up-graation类型的方法可以在这里工作。您需要执行脚本或还原备份文件以获取应用于生产SQL Server的更改。您也可以附加/分离.mdf文件，但它有不同的用途。



希望我澄清了这些事情。我相信，一些谷歌搜索可以帮助解决你的疑虑：）

No, you can't do that. The purpose of dll is totally different from sql script. You need to understand these terms properly.
A dll is Microsoft's implementation of the shared library concept and is works as a library for your project. Whereas your data in SQL Server resides in a .mdf file and no dll up-gradation kind of approach will work here. Either you need to execute the script or restore a backup file to get the changes applied to the production SQL Server. You can also attach/detach the .mdf file but it has a different purpose.

Hopefully, I have clarified the things. I believe, some google search can help clearing your doubts :)

这篇关于我可以像在生产服务器中编译的代码一样在sql server中部署dll吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！