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屋!