Circular references in Visual Studio Database Edition

Question

I'm using Visual Studio Database Edition to script a number of databases. Many of the databases have references between them - for example, view in database A might do select ... from B..TableX

This works fine as long as database B is also a project in the solution. The problem comes in when I have objects in database A referencing database B and database B referencing objects in database A. It seems like Visual Studio needs to build the projects in order which is obviously not possible in this case.

How do you deal with circular references between database projects in Visual Studio database edition?

Answer 1

Definitely a hassle. I've dealt with this by initially setting individual objects in project A which are dependent on project B to "not build" (right click object>properties). Then building the project. Once this completes you can build project B. And then go back and set the objects in Project A back to "build".