Clever Geek Handbook

Does SQL Azure support relational databases?

I keep reading that SQL Azure does not support relational databases; however, I just applied SQL Azure Database and created a relational database.

I even checked to see what it was using:

select * from sys.objects

Any thoughts?

+2


source to share


4 answers


From MSDN:

Introducing Azure SQL Database

Relational data model



SQL Azure will seem very familiar to developers and administrators because data is stored in SQL Azure just like it is in SQL Server using Transact-SQL. Conceptually similar to an in-place SQL Server instance, Azure SQL Server is a logical grouping of databases that acts as an authorization boundary.

Within each Azure SQL Server, you can create multiple databases that have tables, views, stored procedures, indexes, and other familiar database objects. This data model makes good use of the existing relational database design and Transact-SQL programming skills, and also simplifies the process of migrating existing database applications to Azure SQL. For more information on Transact-SQL and its relationship to SQL Azure, see Transact-SQL Overview (Azure SQL Database).

Azure SQL servers and databases are virtual entities that do not correspond to physical servers and databases. By isolating you from the physical implementation, SQL Azure allows you to waste time developing the database.

+4


source


SQL Azure is a relational database on Azure. under the hood SQL Azure is SQL 2008 running in the cloud for TDS access. so if you want, you can create an application using SQL 2008 locally (there are fewer restrictions ) and then change the connection string to SQL Azure and your application will work. For more information http://www.microsoft.com/azure/sql.mspx http://msdn.microsoft.com/en-us/sqlserver/dataservices/default.aspx



+3


source


You might get confused with the old "SQL Server Data Services" (now Azure Table Storage) which doesn't really support relational databases. Developer comments that this was unacceptable led to the implementation of a fully relational SQL Azure.

+2


source


Yes, Azure Table Storage is a non-relational storage service in Azure. There is also blob storage, which is the third storage in Azure.

0


source






More articles:


All Articles