如何通过MsBuild命令行部署CLR存储过程？

Question

我可以通过右键单击SqlClr项目并选择“部署”来部署该项目。然而，我希望有一个命令行版本，可以指定自定义的ConnectionString。

- Tahereh Farrokhi

---

打开VS命令提示符。然后运行devenv /deploy /out log.log yoursolution.sln。在log.log中查找部署的线索，抱歉我无法提供更好的解释:/ - Pasi Savolainen

如果你能接受别人的答案，人们更有可能回答你的问题。 - Justin Dearing

Answer 1

命令为msbuild MySqlClrProject.csproj /T:deploy。这假定代码已构建，并且至少在我的机器上，默认情况下构建调试版本。如果您想重新构建解决方案，部署发布二进制文件，并使用自定义连接字符串，则命令为msbuild MySqlClrProject.csproj /T:Clean;Build;Deploy /p:Configuration=Release;ConnectionString="Data Source=.;Initial Catalog=dropme;Integrated Security=True"

您需要从x86 2010命令提示符（MSBuild 4.0）执行此操作。它无法在Visual Studio 2008（MSBuild 3.5）中工作。我没有Visual Studio 2012来查看它是否适用。

如果您尝试从64位命令提示符运行此命令，您将收到以下消息：

c:\Users\jdearing\Documents\MySqlClrProject\MySqlClrProject.csproj(48,11): error MSB4019: The imported project "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\SqlServer.targets" was not found. Confirm that the path in the <Import> declaration is correct, and that the file exists on disk.     

以下是成功运行该命令的示例：

Setting environment for using Microsoft Visual Studio 2008 x86 tools.

C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC>cd c:\Users\jdearing\Documents\MySqlClrProject

c:\Users\jdearing\Documents\MySqlClrProject>msbuild MySqlClrProject.csproj /T:deploy
Microsoft (R) Build Engine Version 4.0.30319.1
[Microsoft .NET Framework, Version 4.0.30319.261]
Copyright (C) Microsoft Corporation 2007. All rights reserved.

Build started 7/11/2012 4:58:04 PM.
Project "c:\Users\jdearing\Documents\MySqlClrProject\MySqlClrProject.csproj" on node 1 (Deploy target(s)).
SqlClrDeploy:
  Beginning deployment of assembly MySqlClrProject.dll to server . : dropme
  The following error might appear if you deploy a SQL CLR project that was built for a version of the .NET Framework that is incompatible with the target instance of SQL Server: "Deploy error SQL01268: CREATE ASSEMBLY for assembly failed because assembly failed verification". To resolve this issue, open the properties for the project, and change the .NET Framework version.
  Deployment script generated to:
  c:\Users\jdearing\Documents\MySqlClrProject\bin\Debug\MySqlClrProject.sql

  Dropping [MySqlClrProject].[SqlAssemblyProjectRoot]...
  Creating [MySqlClrProject].[SqlAssemblyProjectRoot]...
  The transacted portion of the database update succeeded.
  Deployment completed
AfterDeploy:
  ---SqlReference---
  Data Source=.;Initial Catalog=dropme;Integrated Security=True
Done Building Project "c:\Users\jdearing\Documents\MySqlClrProject\MySqlClrProject.csproj" (Deploy target(s)).


Build succeeded.
    0 Warning(s)
    0 Error(s)

Time Elapsed 00:00:09.37

c:\Users\jdearing\Documents\MySqlClrProject>

- Justin Dearing