This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 96%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
Hi all,
what is alternative method to migrating side by side large size Database
thanks for all reply
regards,
Urbel
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Hi @Urbel,
As mentioned by the @Erland Sommarskog , more details about the migration scenario would help the community provide accurate guidance. For example:
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.
Hi @Urbel,
Just checking back could you please share a few more details about your migration setup (source/target versions, migration type, and downtime window)?
This will help suggest the best approach for your 11 TB database.
Thanks,
Akhil.
Answer recommended by moderator
Hi all,
thanks for its valued respond,
the database is on -premise and plan to migrate to on-premise, the size of Database is almost 10TB and my organization tolerance for downtime, what is technology will be used, I need to know from you of all...
great thanks
warm regards,
UrBel
the database is on -premise and plan to migrate to on-premise, the size of Database is almost 10TB and my organization tolerance for downtime, what is technology will be used, I need to know from you of all...
BACKUP/RESTORE would be the normal thing to do. To reduce downtime, first restore a full backup with NORECOVERY, and then do log shipping until the cutover.
AI answer
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.