Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is SQL Azure a relational database?

I don't really get this. Maybe it's a dumb question.

Is SQL Azure a relational db or it acts just like it?

Using ADO.NET and LINQ I've created a relational or non-relational database?

(I know these questions sound weird......!)

EDIT:

Ok, with one of the answers I've understood an important thing and I can know explain better my question.

i.e.: I've created a non-relational db for my app. Publishing it on Azure and loading on SQL Azure the database will the db be relational or not?

I think it will still be non-relational for the missing of primary keys and foreign keys. Will I get any errors?

So which is the utility of the Table Storage service?

like image 780
Enrichman Avatar asked Feb 28 '26 18:02

Enrichman


2 Answers

Yes, SQL Azure is a relational database management system. The difference between SQL Azure and traditional MS SQL Server is that SQL Azure is designed to be run with high redundancy (i.e. multiple instances).

like image 81
Eric Andres Avatar answered Mar 03 '26 09:03

Eric Andres


Yes, SQL Azure is fully relational cloud database solution.

"Microsoft SQL Azure Database is a cloud-based relational database platform built on SQL Server technologies." extracted from Introducing SQL Azure Database http://msdn.microsoft.com/en-us/library/windowsazure/ee336230.aspx.

like image 45
Ivan Fioravanti Avatar answered Mar 03 '26 08:03

Ivan Fioravanti