SQL Server(Azure Cloud) - Maximum storage size

Question

Hello,
in my company we use the sql server azure cloud, and we are almost reaching the maximum data size. We want to separate some existing data in the database, as it is already old, but we don't want to delete them, just separate to reduce space and improve performance. In this case, what is indicated to do and how to do it?
Thanks.

Answer 1

You may want to consider move that data to new Azure SQL Database and consider using Elastic Queries if you need to query recent data (actual database) and old data (new database with old data.

You may also consider implementing sharding. Here is how to move data between databases.