Joel Paula
-
6 votes
-
14 votes
-
17 votescompleted ·
AdminGuy Haycock
(Senior Product Planner, Microsoft Windows Azure)
responded
The December ’11 update to SQL Azure added new import/export features between SQL Server and SQL Azure. Details at http://sqldacexamples.codeplex.com/wikipage?title=Import%20Export%20Service%20Client&referringTitle=Documentation
-
502 votes
-
2,061 votesplanned ·AdminGuy Haycock
(Senior Product Planner, Microsoft Windows Azure)
responded
thanks, we hear you loud and clear. Free text search is planned for SQL Azure. Right now I can’t give you a date.
-
57 votescompleted ·AdminGuy Haycock
(Senior Product Planner, Microsoft Windows Azure)
responded
Support for user controlled collations was added in the late 2011 service release. For more details please see http://msdn.microsoft.com/en-us/library/windowsazure/ff602419.aspx
Essential for non-English environments
In the real world we have thousands of places in a given application where you can make a search like
SELECT * FROM T WHERE T.Name like '%João%'
We would have to change everything to something like
SELECT * FROM T WHERE T.Name like '%João%' COLLATE SQL_Latin1_General_CP1_CI_AI
It is an impossible task that prevents us from adopting SQL Azure. Accent Insensitive is mandatory for a really large number of users.