Automated deployment for web applications and databases
Moderators: Mike Upton, justin.caldicott, Sean.newham, csmith, chirayu, DavidSimner, david.conlin
I'm trying to deploy a database that contains fulltext catalogs and we are experiencing an issue whereby the Fulltext Catalogs are being added to the upgrade scripts after the procs that are using it which is causing an error during deployment.
Is there a way to change the order this is created or is there some other way around this?
- Posts: 18
- Joined: Wed Sep 25, 2013 1:22 pm
As you say you need to deploy the Full Text objects first, then do the procedures.
Unfortunately Deployment Manager does not support object selections, so the work around would be to use SQL Compare and select the Full Text objects and the Tables in the Filter setup and deselect the other options. Then use the Deployment Wizard and deploy these objects first before trying to run the deployment. (This may not work as some references might cause issues.)
- Posts: 40
- Joined: Mon Mar 30, 2009 2:53 pm
Return to Deployment Manager
Who is online
Users browsing this forum: No registered users and 0 guests