SQL Azure

When using the Generate Schema and Evolve Schema with Windows SQL Azure all tables must have a clustered index.

image

Luckily this is standard in ECO maintained databases – with one exception – the table that helps ECO to remember what tables there are – the TablesTable. This is usually named ECO_TABLES (name can be overridden).

There is a new PersistenceMapper Configuration setting that tells eco that the even the TablesTable should have Clustered index:

image

The setting is called TablesTableHasIndex. Set it to true when using SQL Azure.

image

It had to be a setting to stay compatible with all the other database options.

This entry was posted in Azure, MS-Technology. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*