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?
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:
Is this a limitaion in sql server or your products?