开发者

Using a VS2010 Database Project for only specific schemas in another database

thanks for reading...

Here's my problem:

The Background: I have been tasked with being a Build Manager (first time doing so). Among other things, this includes creating scripts to update the staging DB. I would like to utilize a Database Project for this so I may keep it in source control and also have it apart of TFS Labels to create a snapshot of the DB at the time of the build. This seems pretty straight forward to me.

The Setup: In our dev environment, we have a copy of our production DB. This DB is the one where our new data base objects will be deployed when we go live. We also have a copy of it in staging for testing.

The Goal: The only schemas (and related objects) I need in the Database Projects are limited only to the ones that aren't in production.

The Problem: When I create a new Database Project, I have no option to select only cer开发者_运维知识库tain schemas to import (that I am aware of). Is there a way to only import Schemas A, B, and D and leave out dbo and C? Along with this, is it possible when using the 'Schema Comparison' to compare only selected schemas within the database?

Please let me know if my question and information are incomplete.

Thanks.

-Justin

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜