Activity overview
Latest activity by ChloeC
Migrating backend database
I'm having some problems moving our monitor repository database from a SQL 2012 instance to SQL 2014. The documentation seems to imply that a re-install is needed, and I've done that, and the proce...
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.
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...
Fulltext and Filegroups
Does SQL Compare supports fulltext indexes on non-default filegroups? When I try to synch against a database which has these created manually it creates them on the default, though tables and index...