Fulltext Catalogs

Automated deployment for web applications and databases

Moderators: Mike Upton, justin.caldicott, Sean.newham, csmith, chirayu, DavidSimner, david.conlin

Fulltext Catalogs

Postby notbenjamin » Mon Sep 30, 2013 4:16 pm

Hi there

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?
notbenjamin
 
Posts: 18
Joined: Wed Sep 25, 2013 1:22 pm

Postby Emma A » Thu Oct 03, 2013 12:35 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.)
Emma A
 
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