Migrating Large Size scale Database

Question

Migrating Large Size scale Database

Urbel 465

Hi all,

what is alternative method to migrating side by side large size Database

thanks for all reply

regards,

Urbel

Erland Sommarskog 133.2K Reputation points MVP Volunteer Moderator

2026-02-24T22:25:21.02+00:00

Can you be more specific? Are you migrating from on-Prem to Azure? Or something else? The more information you can share about your migration project, the better your chances for a precise answer.
Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator

2026-03-09T04:54:15.2933333+00:00
Hi @Urbel,

As mentioned by the @Erland Sommarskog , more details about the migration scenario would help the community provide accurate guidance. For example:

Source and target SQL Server versions

Whether the migration is on-premises to on-premises, on-premises to Azure, or another environment

Downtime tolerance

Whether technologies like Backup/Restore, Log Shipping, Always On, or Database Mirroring are options in your environment

Since the database size is ~11 TB, the migration approach can vary significantly depending on these factors.

Please share a bit more information about your setup so the community can suggest the most suitable method.

Thanksm
Akhil.

1 answer

Your answer

Erland Sommarskog 133.2K Reputation points MVP Volunteer Moderator

2026-02-24T22:25:21.02+00:00

Can you be more specific? Are you migrating from on-Prem to Azure? Or something else? The more information you can share about your migration project, the better your chances for a precise answer.
Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator

2026-03-09T04:54:15.2933333+00:00

Hi @Urbel,

As mentioned by the @Erland Sommarskog , more details about the migration scenario would help the community provide accurate guidance. For example:

Source and target SQL Server versions

Whether the migration is on-premises to on-premises, on-premises to Azure, or another environment

Downtime tolerance

Whether technologies like Backup/Restore, Log Shipping, Always On, or Database Mirroring are options in your environment

Since the database size is ~11 TB, the migration approach can vary significantly depending on these factors.

Please share a bit more information about your setup so the community can suggest the most suitable method.

Thanksm
Akhil.

Answer 1

For migrating large size databases side by side, one alternative method is to use the Azure Database Migration Service. This fully managed service enables seamless migrations from multiple database sources to Azure data platforms with minimal downtime. It is particularly useful for large-scale migrations as it supports various database types and can handle significant data volumes efficiently.

Additionally, you can consider using the Azure Data Factory pipeline feature for offline migrations. This method is suitable for large data sizes and allows you to migrate data from on-premises databases to Azure SQL Database or SQL Server on Azure VM. It involves creating a data factory or using an existing one, configuring the necessary integration runtime, and monitoring the migration process through the Azure portal.

Both methods provide robust options for managing large database migrations effectively.

Urbel 465 Reputation points

2026-02-24T02:54:44.9466667+00:00

this project is migration both SQL On premise with size of DB 11TB

any alternative solution

regards

UrBel

Share via

Migrating Large Size scale Database

1 answer

Your answer