How can we help you today? How can we help you today?

Differences in fulltext catalog not detected

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.
R. Schreurs
0

Comments

2 comments

Sort by
  • 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?
    Chris Auckland
    0
  • 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>
    R. Schreurs
    0

Add comment

Please sign in to leave a comment.