Differences in fulltext catalog not detected

R. Schreurs

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 [Zoek vraag & antwoord]
ON FILEGROUP [PRIMARY]
--IN PATH 'd:\mssql\data'
WITH ACCENT_SENSITIVITY = OFF
AUTHORIZATION [dbo]
GO

The left-hand side had the following additional lines

-- Full Text Catalog Tables

CREATE FULLTEXT INDEX ON [dbo].[Followup] KEY INDEX [PK_Fllowup] ON [Zoek vraag & antwoord]
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

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

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!.

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