After performing a data compare if I generate a sync script to make the destination look like the source and choose the option to drop/re-create foreign keys and indexes, the creation script is not handling index names that contain spaces correctly (it is omitting the square brackets).
Example:
CREATE NONCLUSTERED INDEX Check Account ON [dbo].[Check Register Items]
([Check Account] ASC)
WITH (PAD_INDEX = OFF,
FILLFACTOR = 92,
IGNORE_DUP_KEY = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON
)
Should have been
CREATE NONCLUSTERED INDEX [Check Account] ON [dbo].[Check Register Items]
Another example:
CREATE NONCLUSTERED INDEX IX_General Ledger Transaction ON [dbo].[General Ledger Transaction]
should have been:
CREATE NONCLUSTERED INDEX [IX_General Ledger Transaction] ON [dbo].[General Ledger Transaction]
Darren