代码部署本地dacpac失败,已排查基础项求技术解决方案
代码部署DAC包(DACPAC)失败,但SSMS手动部署成功
我本地有一个DACPAC文件,尝试用C#代码部署到SQL Server 2016时碰了壁——代码执行就失败,但奇怪的是,在SQL Server Management Studio里手动部署这个包却完全没问题。我用的部署代码如下:
private static void CreateDatabase() { using (var dacPackage = DacPackage.Load(DacPacFullPath)) { var dacServices = new DacServices(Shared.Environment.Settings.RadanDbNameOrConnectionString()); dacServices.Deploy(dacPackage, DatabaseName, true); } }
我已经做了以下排查,都没找到问题:
- 确认
DacPacFullPath路径完全正确,程序能正常加载到DAC包 - 检查了
dacServices的连接字符串格式,没有错误 - 用连接字符串里的凭据手动登录目标SQL Server,完全没问题
- 在SSMS里手动部署这个DACPAC,一次就成功了
环境信息
SQL Server 2016 版本详情
- Microsoft SQL Server Management Studio 13.0.16106.4
- Microsoft Analysis Services Client Tools 13.0.1700.441
- Microsoft Data Access Components (MDAC) 10.0.16299.15
- Microsoft MSXML 3.0 4.0 6.0
- Microsoft Internet Explorer 9.11.16299.0
- Microsoft .NET Framework 4.0.30319.42000
- 操作系统版本 6.3.16299
Visual Studio 2015 版本详情
- Microsoft Visual Studio Professional 2015 Version 14.0.25431.01 Update 3
- Microsoft .NET Framework Version 4.7.02556
- 已安装版本:Professional
- LightSwitch for Visual Studio 2015 00322-40000-00000-AA922
- Microsoft LightSwitch for Visual Studio 2015
- Visual Basic 2015 00322-40000-00000-AA922
- Microsoft Visual Basic 2015
- Visual C# 2015 00322-40000-00000-AA922
- Microsoft Visual C# 2015
- Visual C++ 2015 00322-40000-00000-AA922
- Microsoft Visual C++ 2015
- Application Insights Tools for Visual Studio Package 7.0.20622.1
- ASP.NET and Web Tools 2015.1 (Beta8) 14.1.11107.0
- ASP.NET Web Frameworks and Tools 2012.2 4.1.41102.0
- ASP.NET Web Frameworks and Tools 2013 5.2.40314.0
- Common Azure Tools 1.8
- JavaScript Language Service 2.0
- JavaScript Project System 2.0
- JetBrains ReSharper Ultimate 2016.2.2 Build 106.0.20160913.91321
- Microsoft Azure Mobile Services Tools 1.4
- NuGet Package Manager 3.4.4
- PreEmptive Analytics Visualizer 1.2
- SQL Server Data Tools 14.0.60519.0
- TypeScript 1.8.36.0
有没有大佬能帮忙分析下代码部署失败的原因?或者有没有什么我漏掉的排查点可以试试?
内容的提问来源于stack exchange,提问作者Abe
相关产品推荐
相关产品推荐

