I have 1TB data on SQL Server VM and would like to migrate to Azure SQL.

Is 500GB really the max? Any compression available so that I can fit 1TB

Hi,

At the moment, the maximum size of the database is 500GB which you get with the Premium Databases. Perhaps,you could take a look at Azure SQL Database Elastic Scale. It is in Preview at the moment.

http://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-scale-introduction/

Regards,

Mekh.

• Marked as answer by Casey KarstMicrosoft employee, Moderator 15 hours 4 minutes ago

Hi,

At the moment, the maximum size of the database is 500GB which you get with the Premium Databases. Perhaps,you could take a look at Azure SQL Database Elastic Scale. It is in Preview at the moment.

http://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-scale-introduction/

Regards,

Mekh.

• Marked as answer by Casey KarstMicrosoft employee, Moderator 14 hours 53 minutes ago

Hi,

on the contrary, this was announced a while back but for some reason the announcement was pulled out

it seems there's support for compression though, check: http://thomaslarock.com/2014/06/microsoft-azure-sql-database-data-compression/

I don't think you can compress 1TB data to SQL Azure.

Request to provide your feedback

http://feedback.azure.com/forums/217321-sql-database/suggestions/403510-allow-data-compression-to-improve-size-performanc

Girish Prajwal

Hi,

At the moment, the maximum size of the database is 500GB which you get with the Premium Databases. Perhaps,you could take a look at Azure SQL Database Elastic Scale. It is in Preview at the moment.

http://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-scale-introduction/

Regards,

Mekh.

• Marked as answer by Casey KarstMicrosoft employee, Moderator Wednesday, March 25, 2015 4:13 PM

Hi,

At the moment, the maximum size of the database is 500GB which you get with the Premium Databases. Perhaps,you could take a look at Azure SQL Database Elastic Scale. It is in Preview at the moment.

http://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-scale-introduction/

Regards,

Mekh.

• Marked as answer by Casey KarstMicrosoft employee, Moderator Wednesday, March 25, 2015 4:13 PM

Hi,

At the moment, the maximum size of the database is 500GB which you get with the Premium Databases. Perhaps,you could take a look at Azure SQL Database Elastic Scale. It is in Preview at the moment.

http://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-scale-introduction/

Regards,

Mekh.

• Marked as answer by Casey KarstMicrosoft employee, Moderator Wednesday, March 25, 2015 4:13 PM

Hi,

At the moment, the maximum size of the database is 500GB which you get with the Premium Databases. Perhaps,you could take a look at Azure SQL Database Elastic Scale. It is in Preview at the moment.

http://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-scale-introduction/

Regards,

Mekh.

• Marked as answer by Casey KarstMicrosoft employee, Moderator Wednesday, March 25, 2015 4:13 PM