Comments
Sort by recent activity
Thanks
The ignore option is not enabled. An example of the scripts seen in the compare window is:-
CREATE TABLE [dbo].[Cartographics]
(
[CartographicsID] [bigint] NOT NULL IDENTITY(1, 1),
[SubjectID] [bigint] NOT NULL,
[Scale] [varchar] (50) COLLATE Latin1_General_CI_AS NULL,
[Projection] [varchar] (50) COLLATE Latin1_General_CI_AS NULL,
[Value] [varchar] (50) COLLATE Latin1_General_CI_AS NULL
) ON [DATA]
GO
-- Constraints and Indexes
ALTER TABLE [dbo].[Cartographics] ADD CONSTRAINT [PK_Cartographics] PRIMARY KEY CLUSTERED ([CartographicsID]) ON [DATA]
GO
-- Foreign Keys
ALTER TABLE [dbo].[Cartographics] ADD CONSTRAINT [FK_Cartographics_Subject] FOREIGN KEY ([SubjectID]) REFERENCES [dbo].[Subject] ([SubjectID])
GO
-- Full Text Information
CREATE FULLTEXT INDEX ON [dbo].[Cartographics] KEY INDEX [PK_Cartographics] ON [MDDB_Cartographics]
GO
ALTER FULLTEXT INDEX ON [dbo].[Cartographics] ADD ([Value] LANGUAGE 1033)
GO / comments
Thanks
The ignore option is not enabled. An example of the scripts seen in the compare window is:-
CREATE TABLE [dbo].[Cartographics]
(
[CartographicsID] [bigint] NOT NULL IDENTITY(1, 1),
[SubjectI...
Yes - the filgroup exists. If it didn't I would have expected the script to try and use them and fail (as it does for CREATE TABLE and CREATE INDEX), not just ignore their existence. / comments
Yes - the filgroup exists. If it didn't I would have expected the script to try and use them and fail (as it does for CREATE TABLE and CREATE INDEX), not just ignore their existence.