SQL Azure

Azure SQL Database (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.

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.

Full Convert supports SQL Azure database directly. SQL Azure is also known as Azure, Microsoft Azure, SQL Server Azure

SQL Azure data types we support

Integral

bigint, int, smallint, tinyint

Decimal

decimal (numeric), double, float (real), money, smallmoney

Text

char, nchar, ntext, nvarchar (sysname), nvarchar(max), text, varchar, varchar(max)

Binary

binary, 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

Export SQL Azure database

It may make sense to migrate your data away from SQL Azure. You may want to do it permanently or just need to share your tables with a collague in a different format.

We will copy all your tables with their data and apply indexing and relationships exactly as they are in your current SQL Azure database. In a nutshell, you get exactly the same database in another database engine. Each time you run the migration, we will copy all the tables again. Of course, we have a built-in scheduler, so you can run this overnight and have a fresh database copy in the morning.

Take a look at the quick tutorials below to see how it's done.

Import data into SQL Azure database

Additionally, if you want to import data on a regular basis and do not want to recreate the whole target database from scratch every time, but rather do tiny targeted sync of only changes since the last run, please use Full Convert Pro or Ultimate.

Take a look at the quick tutorials below to see how it's done.