Views with index and fulltextindex

Andreas

I'm have some problems generating scripts and comparing/syncing two databases that have several views that are indexed for fulltext.
It seems sqlserver won't generate scripts for this, unless you use tasks->generate scripts wizzard in sql managment studios.

Your tools seems to have the same limitation, and i had some problem with dependencies using sql compare and my databases.

one of the views are defined as follows:

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[BrukerTextView]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[BrukerTextView]
WITH SCHEMABINDING 
AS
SELECT     BrukerID, ISNULL(Fornavn, '''') + '' '' + ISNULL(Etternavn, '''') + '' '' + ISNULL(Adresse, '''') + '' '' + ISNULL(Postnummer, '''') + '' '' + ISNULL(Poststed, '''') 
                      + '' '' + ISNULL(Profiltekst, '''') AS text
FROM         dbo.Bruker
WHERE     (Rolle = 1) AND (Status = 1)
' 
GO
SET ARITHABORT ON
GO
SET CONCAT_NULL_YIELDS_NULL ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
SET ANSI_PADDING ON
GO
SET ANSI_WARNINGS ON
GO
SET NUMERIC_ROUNDABORT OFF
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[BrukerTextView]') AND name = N'dd')
CREATE UNIQUE CLUSTERED INDEX [dd] ON [dbo].[BrukerTextView] 
(
	[BrukerID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
IF not EXISTS (SELECT * FROM sys.fulltext_indexes fti WHERE fti.object_id = OBJECT_ID(N'[dbo].[BrukerTextView]'))
CREATE FULLTEXT INDEX ON [dbo].[BrukerTextView](
[text] LANGUAGE [English])
KEY INDEX [dd] ON [db_fulltext]
WITH CHANGE_TRACKING AUTO

Is this a limitaion in sql server or your products?

JonathanWatts

Andreas,

Unfortunately you are correct, SQL Compare does not support full text indexes on views. We hope to have this resolved shortly.

Regards,

Jonathan