Hey everyone,
I'm trying to find an easy and reliable method to copy an Azure SQL Database that's around 500GB from one subscription to another. Both subscriptions are managed under the same Azure Active Directory tenant, so I'm hoping there's a straightforward way to handle this. Any advice or best practices would be much appreciated!
3 Answers
If you're dealing with larger databases, like 2 TB or more, I highly recommend using the sqlpackage tool. The export feature in the portal isn’t reliable once you surpass the 500GB mark. It's been a game changer for my migrations!
I usually go for the backup and restore option through a storage account. It tends to work well for transferring databases between subscriptions. Plus, you get the added security of having a backup!
One of the simplest methods I've found is to copy or clone the database into a different resource group within the same subscription and then just move that new resource group to the other subscription. It's pretty efficient!
Yeah, sqlpackage is fantastic for heavy lifting! I had the same issue with exports before, and it really comes in handy.