Possible to use dbaclone with Azure SQL sources? #158
-
|
Hi all, I am looking to clone a production SQL DB that is hosted in Azure SQL to a local development copy in a local SQL server. Am I missing something obvious here? Thanks, |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 2 replies
-
|
Hi Dan, Cloning data from an Azure SQL DB does come with some extra challenges. The fact is that with Azure SQL DB you don't have any local backups, or are able to run a backup-restore to create the image. The only way I think that this could work with Azure SQL DB, is when you export the data from your Azure SQL DB to a BACPAC, deploy that BACPAC to create the database locally and then use that local copy to create the images and eventually the clones. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks for the info, this is kind of where I have landed so far. |
Beta Was this translation helpful? Give feedback.
-
|
Hi I'm digging into this same problem right now. My question is the other way around. Assuming I have the local image all setup can I deploy it to azure sql? |
Beta Was this translation helpful? Give feedback.
Hi Dan,
Cloning data from an Azure SQL DB does come with some extra challenges.
The fact is that with Azure SQL DB you don't have any local backups, or are able to run a backup-restore to create the image.
How dbaclone creates the images is by backing up (or using an existing backup) and restoring that backup inside a VHD file.
The only way I think that this could work with Azure SQL DB, is when you export the data from your Azure SQL DB to a BACPAC, deploy that BACPAC to create the database locally and then use that local copy to create the images and eventually the clones.