SQL Compare and Indexes

If need to include indexes during SQL compare, make sure the following boxes are unchecked in the “options” section…

• Ignore indexes
• Ignore performances indexes

Adding Missing Index

CREATE NONCLUSTERED INDEX [IX_tbTable01_biCol01] ON [dbo].[tbTable01] ([biCol01], [biCol02]) INCLUDE ([biCol03], [biCol04])
GO