Differences in fulltext catalog not detected

R. Schreurs · February 12, 2010 7:31AM

I compared two databases in which I expected some differences between two full text catalogs.

In the comparison result, the fulltext catalog was reported under identical objects.

However, when I looked at the details, the scripts were different:

The right-hand side had

-- Full Text Catalog

CREATE FULLTEXT CATALOG &#91;Zoek vraag & antwoord&#93;
ON FILEGROUP &#91;PRIMARY&#93;
--IN PATH 'd:\mssql\data'
WITH ACCENT_SENSITIVITY = OFF
AUTHORIZATION &#91;dbo&#93;
GO

The left-hand side had the following additional lines

-- Full Text Catalog Tables

CREATE FULLTEXT INDEX ON &#91;dbo&#93;.&#91;Followup&#93; KEY INDEX &#91;PK_Fllowup&#93; ON &#91;Zoek vraag & antwoord&#93;
GO

(and a supposedly irrelevant different "IN PATH" comment.)

I would have expected SQL Compare to detect this difference.

I am running version 8.1.0.360, which is reported as the latest version.

Chris Auckland · February 15, 2010 6:11AM

Thanks for your post.

SQL Compare should detect this difference with the default options.

Can you check that you don't have 'ignore' > 'Full-text indexing' selected?

R. Schreurs · February 15, 2010 3:35PM

Thanks for your reply.

The option Fill-text indexing is not checked in the section Ignore.

For your information, I have included a copy of the project file below. All data that seemed sensitive have been replaced with !ERASED!.

&lt;?xml version="1.0" encoding="utf-8"?&gt;
&lt;Project version="1" type="SQLComparisonToolsProject"&gt;
	&lt;DataSource1 version="2" type="LiveDatabaseSource"&gt;
		&lt;ServerName&gt;!ERASED!&lt;/ServerName&gt;
		&lt;DatabaseName&gt;!ERASED!&lt;/DatabaseName&gt;
		&lt;Username&gt;!ERASED!&lt;/Username&gt;
		&lt;SavePassword&gt;!ERASED!&lt;/SavePassword&gt;
		&lt;Password encrypted="!ERASED!"&gt;!ERASED!&lt;/Password&gt;
		&lt;IntegratedSecurity&gt;!ERASED!&lt;/IntegratedSecurity&gt;
	&lt;/DataSource1&gt;
	&lt;DataSource2 version="2" type="LiveDatabaseSource"&gt;
		&lt;ServerName&gt;!ERASED!&lt;/ServerName&gt;
		&lt;DatabaseName&gt;!ERASED!&lt;/DatabaseName&gt;
		&lt;Username&gt;!ERASED!&lt;/Username&gt;
		&lt;SavePassword&gt;!ERASED!&lt;/SavePassword&gt;
		&lt;Password encrypted="!ERASED!"&gt;!ERASED!&lt;/Password&gt;
		&lt;IntegratedSecurity&gt;!ERASED!&lt;/IntegratedSecurity&gt;
	&lt;/DataSource2&gt;
	&lt;LastCompared&gt;02/15/2010 21:05:42&lt;/LastCompared&gt;
	&lt;Options&gt;317002946838538&lt;/Options&gt;
	&lt;InRecycleBin&gt;False&lt;/InRecycleBin&gt;
	&lt;Direction&gt;0&lt;/Direction&gt;
	&lt;ProjectFilter version="1" type="DifferenceFilter"&gt;
		&lt;FilterCaseSensitive&gt;False&lt;/FilterCaseSensitive&gt;
		&lt;Filters version="1"&gt;
			&lt;None version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/None&gt;
			&lt;Assembly version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/Assembly&gt;
			&lt;AsymmetricKey version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/AsymmetricKey&gt;
			&lt;Certificate version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/Certificate&gt;
			&lt;Contract version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/Contract&gt;
			&lt;DdlTrigger version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/DdlTrigger&gt;
			&lt;Default version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/Default&gt;
			&lt;EventNotification version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/EventNotification&gt;
			&lt;FullTextCatalog version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/FullTextCatalog&gt;
			&lt;FullTextStoplist version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/FullTextStoplist&gt;
			&lt;Function version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/Function&gt;
			&lt;MessageType version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/MessageType&gt;
			&lt;PartitionFunction version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/PartitionFunction&gt;
			&lt;PartitionScheme version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/PartitionScheme&gt;
			&lt;Queue version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/Queue&gt;
			&lt;Role version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/Role&gt;
			&lt;Route version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/Route&gt;
			&lt;Rule version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/Rule&gt;
			&lt;Schema version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/Schema&gt;
			&lt;Service version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/Service&gt;
			&lt;ServiceBinding version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/ServiceBinding&gt;
			&lt;StoredProcedure version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/StoredProcedure&gt;
			&lt;SymmetricKey version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/SymmetricKey&gt;
			&lt;Synonym version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/Synonym&gt;
			&lt;Table version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/Table&gt;
			&lt;User version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/User&gt;
			&lt;UserDefinedType version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/UserDefinedType&gt;
			&lt;View version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/View&gt;
			&lt;XmlSchemaCollection version="1"&gt;
				&lt;Include&gt;True&lt;/Include&gt;
				&lt;Expression&gt;TRUE&lt;/Expression&gt;
			&lt;/XmlSchemaCollection&gt;
		&lt;/Filters&gt;
	&lt;/ProjectFilter&gt;
	&lt;ProjectFilterName /&gt;
	&lt;UserNote /&gt;
	&lt;SelectedSyncObjects version="1" type="SelectedSyncObjects"&gt;
		&lt;Schemas type="ListString" version="2"&gt;
			&lt;value type="string"&gt;!ERASED!&lt;/value&gt;
			&lt;value type="string"&gt;!ERASED!&lt;/value&gt;
		&lt;/Schemas&gt;
		&lt;!ERASED!&gt;!ERASED!&lt;/!ERASED!&gt;
		&lt;!ERASED!&gt;!ERASED!&lt;/!ERASED!&gt;
		&lt;Grouping type="ListByte" version="2"&gt;
			&lt;value type="Byte"&gt;0&lt;/value&gt;
			&lt;value type="Byte"&gt;0&lt;/value&gt;
			&lt;value type="Byte"&gt;0&lt;/value&gt;
			&lt;value type="Byte"&gt;0&lt;/value&gt;
			&lt;value type="Byte"&gt;0&lt;/value&gt;
		&lt;/Grouping&gt;
		&lt;SelectAll&gt;False&lt;/SelectAll&gt;
	&lt;/SelectedSyncObjects&gt;
	&lt;SCGroupingStyle&gt;0&lt;/SCGroupingStyle&gt;
	&lt;SQLOptions&gt;266&lt;/SQLOptions&gt;
	&lt;MappingOptions&gt;82&lt;/MappingOptions&gt;
	&lt;ComparisonOptions&gt;0&lt;/ComparisonOptions&gt;
	&lt;TableActions type="ArrayList" version="1" /&gt;
	&lt;SessionSettings&gt;15&lt;/SessionSettings&gt;
	&lt;DCGroupingStyle&gt;0&lt;/DCGroupingStyle&gt;
&lt;/Project&gt;

Differences in fulltext catalog not detected

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk