Is it possible to automatically deploy dependent database projects in VS2008 Database Edition?
I have two database projects, let's call them A and B. B depends on A (B doesn't create the database but A does, etc.). I want to be able to 'Deploy' B on demand and have A automatically deploy first.
I know it's possible to configure the solution through Solution Properties | Configuration Properties to "deploy" the database projects and then selecting 'Deploy' on B automatically deploys A first but the problem with this approach is that VS will also deploy the databases every time we start our solution.
This is not practical since there is quite a significant amount of data that needs to be injected into the database after a deployment (and currently our database schema is fairly stable, so doesn't really need to be deployed very often).
If I uncheck the "deploy" option in the Configuration Properties page, then VS skips over deploying 'A' when I deploy 'B' because it claims the project isn't selected in the configuration:
------ Skipped Deploy: Project: A, Configuration: Release Any CPU ------
Project not selected to build for this solution configuration