What databases do users use in cloud environments with ASP.NET/ASP.NET MVC?

Question

I am considering hosting a new site in a cloud service. This seems like a cool technology, pricing is attractive, and I can scale if my plans for global Internet dominance pay off.

I spent a good chunk of time figuring out what to use for thought. The site is in ASP.NET MVC, and I came across a brick wall when it comes to SQL Server. I am not interested in paying for licensing only a small site. This is great for daytime work, but I'm browsing it for this new site.

SQL Azure looks like the price is perfect, but the price of their calculations scared me, and Core of the development accelerator is too risky with the terms of the contract.

I tested all sorts of alternative approaches:

• Open source databases (MYSQL, Postgres) with Entity Framework
• Nosql (MongoDB, CouchDB, SimpleDB, DB40, Cassandra)
• Dedicated SQL Server
• SQL Server Web Edition
• Call SQL Azure from another cloud

I am currently planning to host the web server (IIS) and the database server in one instance (1 GB of RAM for Windows 2008 R2), and then scale it as needed.

At this point, I welcome the fact that others have figured out what worked, what didn't work. I appreciate any experience you want to share.

Answer 1

db4o , , , . .

RavenDB . 700 , , . , , NoSQL. CouchDB, .net, Couch (imo).

, BizSpark Microsoft, Azure. , .

.

Answer 2

Sql Azure . , , Azure.

Answer 3

• MySql EF: , , MySql/ , , + ... , .
• db4o: / , . 2 :
  • . , NoSql/ ( , , ).
  • . , . , , .

, . db4o, , , . , , GPL -. : https://stackoverflow.com/questions/94346/can-i-legally-incorporate-gpl-lgpl-open-sourced-software-in-a-proprietary-clo/94468#94468, , . , Chance, , , , - .

Answer 4

orcsweb.com 99 . , , 300 .

, orcsweb.com , - . 124 . .

, 223 .

: sql express 2005 2008. . , . , , .

orcsweb, , ... . - , . 30 , orcsweb. 7 . .

EDIT:

!!:

, -. - SQL Express.

, , - , SQL Express .

Answer 5

Not sure how much data you have in mind, but is there any SQL Express skus? They can handle almost everything that a web application should do with the data, being in the right price category and an easy update path.

Otherwise, I would go with the nosql option, because these days it seems a little more understandable, and it is designed with the cloud in mind.