Full-text catalog & SQL Automation Pack v1.1

sergeyhoroshun

I'm trying to create very simple deploy package for CI

sqlci.exe Build /scriptsFolder=scripts /packageId=CIPackage /packageVersion=1.0 /outputFolder=c:\Packages /temporaryDatabaseServer=.

and have got this error:

sqlCI.exe -- Red Gate's SQL Continuous Integration v2.0.0.56

STARTING: Creating scratch database sqlCI_7f9cc660-c557-469b-a4a6-f34a4eda4a23
COMPLETED SUCCESSFULLY: Creating scratch database sqlCI_7f9cc660-c557-469b-a4a6-f34a4eda4a23
STARTING: Validating database state
...

Error: Synchronization of 'Scripts.state' and '..sqlCI_7f9cc660-c557-469b-a4a6-f34a4eda4a23' failed: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'dbo.Customers' because it is not full-text indexed.

Validating database state failed with error SQLCompare failed with exit code 126: see output above for more information, or for generic information about this exit code, see: http://www.red-gate.com/sqlCI/ExitCodes/SQLCompare

Please tell me a solution or workaround for this issue.


# ./scripts

# Full Text Catalogs/FTC.sql

CREATE FULLTEXT CATALOG [FTC]
WITH ACCENT_SENSITIVITY = ON
AUTHORIZATION [dbo]
GO

# Tables/dbo.Customers.sql

CREATE TABLE [dbo].[Customers]
(
[key] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Customers_key] DEFAULT (newsequentialid()),
[name] [nchar] (10) COLLATE Cyrillic_General_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Customers] ADD CONSTRAINT [PK_Customers] PRIMARY KEY CLUSTERED  ([key]) ON [PRIMARY]
GO
CREATE FULLTEXT INDEX ON [dbo].[Customers] KEY INDEX [PK_Customers] ON [FTC]
GO
ALTER FULLTEXT INDEX ON [dbo].[Customers] ADD ([name] LANGUAGE 1033)
GO

# Stored Procedures/dbo.SP_get_customer.sql

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[SP_get_customer]
AS
BEGIN
	SET NOCOUNT ON;
	SELECT * FROM dbo.Customers
	WHERE CONTAINS(  dbo.Customers.name , N'name')
END
GO