SqlAzure does not support sys.sp_addextendedproperty

[colinangusmackay]

A SQL Azure database does not support a number of things that are available in SQL Server 2012, such as sys.sp_addextendedproperty which means that WithColumnDescription() fails when applied to a SQL Azure database, although it works perfectly fine when applied to a SQL Server 2012 database.

[tommarien]

@colinangusmackay You are right and there seems to be no way around this limitation, either we have to create a special processor that throws an error on this situation or we leave it as is

[eldersantos]

What about create a new Generator called SQL Azure. I have been working with SQl Azure and there is a lot of diffs between SQL Server on premisse and SQL Azure

[tommarien]

@eldersantos Just the description feature seems like not enough to warrant for a new processor/generator any other differences that may have an impact ?

[eldersantos]

@tommarien there are severals, but thinking only about DDL instructions I can say a clustered index is always required on all SQL Azure tables. SQL Azure does not support heap tables, the create table statement will not fail but the INSERT operations will until a clustered index is created.
Sql Azure even supports some of the more specialized data types such as the spatial data types geography and geometry, hierarchyid, but maybe these is too specific.

[tommarien]

@eldersantos Those types are not specific to SqlAzure, heap tables is correct but not sure how to put that in a specific provider/generator though

[eldersantos]

@tommarien I think it is not enough to a new generator too.
Onde option is always consider a PK with clustered index in a table for sql server generator or at least show a warning when the developer do not create one.

[tommarien]

I'll close this issue because not enough reasons to create a sqlazure provider atm