Tables without a clustered index are not supported in this version of SQL Server.

Error

Tables without a clustered index are not supported in this version of SQL Server.

Cause

Some versions of Azure SQL require every table to have a Clustered Index, if you are using this kind of version, you might encounter this issue.

Resolution

You can run the following command to create an Index. Set the <tablename> to the same name you have entered in your MigrationWiz project.

CREATE CLUSTERED INDEX idx_auditlog on <tablename> ( MailboxId, EventTimestamp );
​GO

This will create the necessary Clustered Index and allow MigrationWiz to insert data into the table.

Was this article helpful?
0 out of 0 found this helpful