Full-text catalog & SQL Automation Pack v1.1

Automated deployment for web applications and databases

Full-text catalog & SQL Automation Pack v1.1

Postby sergeyhoroshun » Mon May 26, 2014 9:43 pm

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

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


and have got this error:

Code: Select all
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
Code: Select all
CREATE FULLTEXT CATALOG [FTC]
WITH ACCENT_SENSITIVITY = ON
AUTHORIZATION [dbo]
GO

# Tables/dbo.Customers.sql
Code: Select all
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
Code: Select all
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
sergeyhoroshun
 
Posts: 1
Joined: Mon May 26, 2014 9:23 pm

Return to Deployment Manager

Who is online

Users browsing this forum: No registered users and 0 guests

cron