Forgive me if this turns out to have a really simple solution but I've been struggling with this for a couple of days now and I could do with some help!
Our setup is a bit horrible - lots of cross database queries and views, so to do an initial deployment of any one database requires a few to go out along with it.
I've been trying to set up a database deployment project so I can deploy our system to a new server, but I keep encountering issues when deployment manager reaches the cross database queries. Sometimes, if the database its looking for is due to be deployed in the same project, its fine - it'll skip over the error and deploy it with no trouble, other times it won't, it'll give me deployment failed errors.
Is there any way around this? Thanks in advance for any help provided