DACPAC不包括复合对象 [英] DACPAC not including composite objects

问题描述

我有一个VS2012数据库项目，其中包括表，存储的proc，视图等.

I have a VS2012 database project which includes tables, stored procs, views etc.

然后我有第二个数据库项目，其中包含对第一个项目的数据库引用.我确保从项目属性->调试->高级"菜单中选择包含复合对象"选项.

I then have a second database project which contains a database reference to the first project. I have ensured that the "Include composite objects" options is selected from the "Project Properties -> Debug -> Advanced" menu.

当我构建第二个项目并获取生成的DACPAC文件并通过SSMS2012进行部署时，它不会创建第一个项目的对象.

When I build the second project and take the resulting DACPAC file and deploy it through SSMS2012 it doesn't create the firsts project's objects.

我错过了什么吗?为什么复合对象不包含在DACPAC中?

Am I missing something? Why don't the composite objects get included in the DACPAC?

推荐答案

如彼得·肖特在评论中所说上面，我需要按顺序部署两个输出的Dacpac，首先是引用的数据库.

As Peter Schott said in the comments above, I needed to deploy both outputted Dacpacs in order, with the referenced database first.

您无法通过SSMS执行此操作，这将不允许您将两个不同的Dacpac部署到同一数据库.但这不是通过SQLPackage的问题.

You cannot do this through SSMS, it won't allow you to deploy two different Dacpacs to the same database. But it is not a problem through SQLPackage.

这篇关于DACPAC不包括复合对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！