For new Dataobjects development I am currently using postgresSQL, however I have decided to move to azure to host my applications, so my options are:

  1. Use a azure vm and install postgres on it.
  2. Or move to SQL Azure.

SQL Azure is the easier option within Azure, however I am concerned there may be some limitations for Dataobjects using Azure SQL?

asked Nov 07 '13 at 05:35

Tony's gravatar image

Tony
53262628


One Answer:

Hello Tony,

DataObjects.Net fully supports Azure SQL.

However Azure SQL itself has some limitations comparing to both regular SQL Server and PostgreSQL:

  • No full text search
  • It's impossible to have database without primary key, thus DO can't handle schema upgrades that involve changing key fields

answered Nov 07 '13 at 15:24

Denis%20Krjuchkov's gravatar image

Denis Krjuchkov
179325

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

Subscription:

Once you sign in you will be able to subscribe for any updates here

Tags:

×5

Asked: Nov 07 '13 at 05:35

Seen: 3,490 times

Last updated: Nov 07 '13 at 15:24

powered by OSQA