How to Enable and Create Full Text Search from Visual Studio Database Project

Full Time DBA — Thu, 18 Dec 2008 03:03:01 GMT

1. Enable Full Text Search

a. Open the database project

b. Right Click the database project then select properties

c. On the Project Settings tab, make sure the Enable full text search option is checked

2. Create Full Text Catalog

a. Under Solution Explorer , expand the Database project, expand the Schema Objects -> Storage

b. Right click the Full Text Catalogs, then select Add -> New Item from the context menu

c. Select Storage from Categories panel then select Full Text Catalog from Templates panel

d. Enter the name of the Full Text Catalog you are creating.

e. Enter the creating Full Text Catalog script in the script window then save.

CREATE FULLTEXT CATALOG {FullTextCatalog_ReplaceThisName}

ON FILEGROUP [PRIMARY]

WITH ACCENT_SENSITIVITY = ON

AS DEFAULT

AUTHORIZATION [dbo]

3. Create Full Text Index on a table

a. Under Solution Explorer, expand the database project->Schema Objects -> Table

b. Right click the Indexes folder and select Add New Item

c. Select Tables and Views from Categories panel then select the Full Tex Index from Templates panel

d. Enter the name of the Full Text Index then enter creating Full Text Index script in the window and save it

CREATE FULLTEXT INDEX ON {TableName} KEY INDEX {IndexKeyName} ON {Full Text Catalog Name}

ALTER FULLTEXT INDEX ON {TableName} ADD ({ColumnName})

ALTER FULLTEXT INDEX ON {TableName} ENABLE

Full Time DBA - TFS Database Project