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

Related posts:

  1. The ‘Sqlcmd: Error: Syntax error at line XYZ near command ‘X’ in file ‘file_name.sql’.’ error is encountered when running SQL script via sqlcmd utility
  2. The “Files are in use” error occurs when upgrading ApexSQL Monitor
  3. ApexSQL Recover doesn’t recover all lost data
  4. Crowded Metro menu with ApexSQL icons
  5. ApexSQL add-ins do not integrate with SQL Server Management Studio 18 GA version