Views with index and fulltextindex

AndreasAndreas Posts: 2
edited June 28, 2007 10:17AM in SQL Compare Previous Versions
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?

Comments

  • Andreas,

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

    Regards,

    Jonathan
    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
Sign In or Register to comment.