SQL Comparison SDK 10

SQL Compare deployment error 'Full-Text Search is not installed'

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.


Didn't find what you were looking for?