CODEWITHSUNDEEP
azureazure-sql-database
Natarajan Rajagopal
Natarajan Rajagopal

Reputation: 1

Azure sql Database suggestion

We have DB in on-premise of size around 3TB. We have to move this to azure cloud. What would be the best and cost effective solution? We have an idea to split the DB into multiple DB so that we can reduce the cost of azure sql DB storage? Please suggest us best option here(azure sql DB, sql instance or VM).

Upvotes: 0

Views: 179

Answers (1)

Utkarsh Pal
Utkarsh Pal

Reputation: 4544

Azure SQL Database and Azure SQL Managed Instance are the best options to migrate the existing on premises SQL database to Azure because:

  • No need to setup infrastructure
  • Scalable
  • High Availability (99.99%)
  • Easy to migrate using Data Migration Service

You can choose any of the below mentioned Service tier in Azure SQL database to migrate the database:

  • General purpose (up to maximum 4 TB database size)
  • Hyperscale (support for up to 100 TB of database size)

Meanwhile, Azure SQL Managed Instance has two service tiers: General purpose and Business Critical. In General purpose tier, maximum of 16TB storage is supported with more than 8vCore. Check here for more more details and comparison between service tiers.

Please visit Azure SQL Managed Instance to know more.

Lastly, check the Features comparison: Azure SQL Database and Azure SQL Managed Instance and choose the best.

Upvotes: 0

Related Questions