Fulltext Catalogs
notbenjamin
Posts: 22
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?
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?
Comments
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.)