SQL Compare deployment error 'Full-Text Search is not installed'
Published 06 March 2013
An error may occur when running a deployment produced by SQL Compare API:
Full-Text Search is not installed, or full-text component cannot be loaded
The deployment scripts have the following:
GO PRINT N'Adding full text indexing' GO sp_fulltext_database N'enable' GO
And if the script is run then the message appears: Msg 15601, Level 16, State 1, Procedure sp_help_fulltext_catalogs
Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable Full-Text Search. The functionality to disable and enable full-text search for a database is deprecated. Please change your application.
This may occur because SQL Server 2000's full-text indexing features have not been installed. In order to full-text enable a database, SQL Server 2000 setup must be run to install full-text indexing. If the deployment is going to add full-text indexes to the target database, it is also necessary to create any required full-text catalogs manually, as SQL Compare's API will not do this for you. It would be possible to use the ADO .NET client to create a full-text catalog manually:
using System.Data.SqlClient; SqlConnection conn=new SqlConnection("data source=localhost;initial catalog=master;Integrated Security=SSPI"); SqlCommand cmd=new SqlCommand("exec sp_fulltext_catalog 'MyCatalog','Create'", conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close();
The alternative to installing and enabling full-text indexing on the SQL Server would be to instruct the API to ignore any full-text catalogs that it finds in the database you are deploying to.
Set this option with any others you require by joining them together with a bitwise OR
operator |
, for example:
Options options=Options.Default | Options.IgnoreFullTextIndexing;
In the Visual Basic language, there is no distinction between bitwise and logical operators, hence the Or
operator would be used:
Dim o As Options=Options.Default Or Options.IgnoreFullTextIndexing
This will disable the comparison and deployment of full text objects.