I want to use the Microsoft Data-Tier Application framework and its associated .Net API to manage the schema of several SQL Server databases, including the model database. However, when I try deploy an updated schema to the model database (using either a SQLCMD script or the DacServices.Deploy(...) method), I receive the following error...
Cannot use full-text search in master, tempdb, or model database.
Is there any way around this?
So, I was going over the generated SQLCMD script with my boss, and he saw this...
IF fulltextserviceproperty(N'IsFulltextInstalled') = 1
EXECUTE sp_fulltext_database 'enable';
Why would that be needed for a schema deployment? It would be easy enough to strip that block out of the script, but what if I want to use the DacServices.Deploy(...) method to update the schema? I don't see anything in the DacDeployOptions class that seems like it would affect this deployment option.