Hi Alex,

What are the company's plans for supporting Windows/SQL Azure?


Updated at 12.02.2010 9:25:24

Sweeeeeet! Any limitations?

This thread was imported from our support forum. The original discussion may contain more detailed answer.

asked Feb 12 '10 at 07:54

ara's gravatar image

ara
395878791

Hello,

Azure is already supported. Use azure://... protocol in connection url.

(Feb 12 '10 at 07:54) Dmitri Maximov Dmitri%20Maximov's gravatar image

One Answer:

None, only the ones that are specific to SQL Server running @ Azure:

Those ones that are related to schema (requirement to have clustered indexes @ every table, etc.) are enforced automatically.

Btw, see http://sqlazuremw.codeplex.com/releases/view/32334 - there is NotSupportedByAzureFile.Config in application archive, that describes most of differences related to SQL.


I'm going to publish v4.2 RC this weekend, so if you don't want to play with our source code repository to get the latest build, I recommend you to wait for few days.


I just noticed Dmitri has made a mistake: there is no "azure://" prodocol, you must use "sqlserver://" there, see:

We didn't create a special protocol, since Azure SQL Database reports it is SQL Server of version 10, so we decided to create a provider version for it aware of its limitations (provider version = a special subset of SQL DOM provider classes overriding logic of their bases, it's a standard approach to dealing with RDBMS versions in SQL DOM).

answered Feb 12 '10 at 11:31

Alex%20Yakunin's gravatar image

Alex Yakunin
29714412

My 2 bits (for mere mortals):

  • Azure doesn't have support for Multiple Active Result Sets (MARS).

  • Azure doesn't have full-text search support yet.

(Feb 12 '10 at 11:31) Dmitri Maximov Dmitri%20Maximov's gravatar image
Your answer
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!
toggle preview

powered by OSQA