Red Gate forums :: View topic - Cross Database queries and views
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Deployment Manager
Deployment Manager forum

Cross Database queries and views

Search in Deployment Manager forum
Post new topic   Reply to topic
Jump to:  
Author Message
notbenjamin



Joined: 25 Sep 2013
Posts: 18

PostPosted: Wed Sep 25, 2013 1:27 pm    Post subject: Cross Database queries and views Reply with quote

Hi there

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
Back to top
View user's profile Send private message
notbenjamin



Joined: 25 Sep 2013
Posts: 18

PostPosted: Wed Sep 25, 2013 2:07 pm    Post subject: Reply with quote

So after a bit more digging I realised it only fails on views which then made me realise that this is SQL Server not DM

I'm going to move the views around see if that sorts it
Back to top
View user's profile Send private message
justin.caldicott



Joined: 20 Apr 2011
Posts: 55

PostPosted: Wed Sep 25, 2013 3:04 pm    Post subject: Reply with quote

Glad to hear you've got a possible solution. Keep us posted!
_________________
Justin Caldicott
Product Manager - Deployment Manager
Red Gate
Back to top
View user's profile Send private message
notbenjamin



Joined: 25 Sep 2013
Posts: 18

PostPosted: Mon Sep 30, 2013 5:17 pm    Post subject: Reply with quote

Unfortunately we are still having issues with this. I haven't been able to change or move all of the views, but I have moved some to synonyms instead. I'm still getting "invalid object" issues with the deployments.

Any suggestions?
Back to top
View user's profile Send private message
Emma A



Joined: 30 Mar 2009
Posts: 40

PostPosted: Thu Oct 03, 2013 1:19 pm    Post subject: Reply with quote

If you can determine the dependencies you may be able to deploy all databases in a manually configured order (by using multiple package steps) as long as there are no circular dependencies.

If you could provide the deployment logs where failures occur we might be able to workout what is going on. If you would rather not post it on the forum, you can email support@red-gate.com and mark it FAO. Emma Armstrong.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group