The application adds columns in the synchronization script when creating a clustered columnstore index

Applies to
ApexSQL Diff

Description
This article describes an issue in ApexSQL Diff when creating a clustered columnstore index

Summary
When creating a clustered columnstore index in ApexSQL Diff the synchronization script will be generated with the wrong syntax.

For example, instead of:

CREATE CLUSTERED COLUMNSTORE INDEX [cci_Simple]
	ON [dbo].[SimpleTable]

The script will include table columns, e.g.:

CREATE CLUSTERED COLUMNSTORE INDEX [cci_Simple]
	ON [dbo].[SimpleTable] ([ProductKey], [OrderDateKey], [DueDateKey], [ShipDateKey])

Background
Due to a bug in the ApexSQL Diff a clustered columnstore index is created with a wrong syntax

Affected versions
ApexSQL Diff 2014.01.0293

Planned resolution
ApexSQL is currently working to fix this issue permanently