SQL Azure

Azure SQL Database is a cloud-based data-storage service from Microsoft. It’s based on a special version of Microsoft’s SQL Server. It’s basically a stripped-down SQL Server with certain limitations in place.

We support SQL Azure directly in our products! You don't need separate drivers and can immediately connect to your database.

Azure SQL Database changed its name several times. It was known as SQL Azure in the past.

High availability is provided by storing multiple copies of databases, elastic scale and rapid provisioning. T-SQL can still be used as the query language, as well as stored procedure language. Certain system procedures are no longer available in the cloud version of the database, but overall parity is very high and SQL Server developers should have no problem working with Azure SQL Database.

SQL Azure

data types we support

Integral
bigint
int
smallint
tinyint
decimal
decimal (numeric)
double
float (real)
money
smallmoney
text
char
nchar
ntext
varchar (sysname)
nvarchar(max)
text
varchar
varchar(max)
Binary
bitbinary
bit
timestamp
varbinary
Date/Time
date
datetime
datetime2
datetimeoffset
smalldatetime
time
Large objects
geography
geometry
image
ntext
nvarchar(max)
text
varbinary(max)
varchar(max)
xml
Other
dynamicobject
hierarchyid
sql_variant
table
uniqueidentifier