Forum Discussion
mrvamsidhar
May 22, 2023Copper Contributor
Migrate data from Azure SQL to Azure SQL between two tenants
Hello, Is it possible to use any azure native migration service to migrate data between Azure SQL to Azure SQL between two tenants?
mrvamsidhar
May 22, 2023Copper Contributor
Thank You for your reply. Can you please help me clarify below?
1. Using ADP copy instead Import/Export is a better approach if the data size more than > 10 TB
2. Also, what is the recommended approach for migrating Azure IaaS SQL to Azure IaaS SQL between tenants?
1. Using ADP copy instead Import/Export is a better approach if the data size more than > 10 TB
2. Also, what is the recommended approach for migrating Azure IaaS SQL to Azure IaaS SQL between tenants?
May 22, 2023
If the database is too big , than u need to expect a downtime , or creating a replication of the database in the other tenant than take a snapshot but sometimes this will locks the tables .
Moving a database between Iaas servers is to backup and import. Take a look also ok the azure sql migration service
Moving a database between Iaas servers is to backup and import. Take a look also ok the azure sql migration service