如何拆分数据库项目？
我有三个数据库项目。我想让基础项目包含公用表和其他公用对象。然后，我想让其他两个项目包含特定于版本的对象，这些对象将与应用程序的不同版本一起使用，换句话说，根据我将与之交互的应用程序的版本，我将部署其中一个数据库项目或其他。
我认为，如果我只是在两个版本特定数据库中引用基础数据库项目，然后指示每个数据库项目部署到同一个数据库，它就会起作用，但显然我遗漏了一些东西。当我尝试部署数据库的某个版本时，它说找不到依赖数据库项目中引用的任何对象。
项目构建良好，只是不会为依赖数据库生成部署脚本。它表示基础项目中引用的对象不存在。
我正在尝试使用 Visual Studio 2008 数据库版本 gdr 2 到 2008 数据库服务器来执行此操作。
I've got three database projects. I'd like to have the base project contain common tables and other common objects. And then, I'd like to have the other two projects contain version specific objects that will work with different versions of an application, in other words, depending on the version of the application I will be interfacing with I will be deploying either one database project or the other.
I thought that if I just made a reference to the base database project in the two version specific databases and then instructed each of the database projects to deploy to the same database it would just work but apparently I'm missing something. When I try to deploy a version of the database it says it can't find any the objects that are referenced in the dependent database project.
The projects build fine, a deployment script just won't generate for the dependent database. It says that objects which are referenced in the base project do not exist.
I'm trying to do this with visual studio 2008 database edition gdr 2 to a 2008 database server.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
看起来，如果我将项目设置为部署基础数据库项目脚本，它就可以正常工作。我想我必须始终部署脚本。但我宁愿不必这样做。
It appears that if I set the project to deploy the base database project script it works fine. Guess I have to always deploy the script. I'd prefer to not to have to do that though.