migrating Database backup from One subscription to another frequently

Question

As a user, I currently have one SQL Server deployed in a single Azure subscription. While I don't currently have any automation set up, I believe I can create automation within the same Azure subscription. However, I'm exploring the possibility of creating a new subscription to facilitate the frequent transfer of database backups between different subscriptions in the future. Can you guide whether creating multiple subscriptions would enable me to automate the transfer of databases between subscriptions? and How much time it will consume ? I appreciate any insights you can offer on this matter.
I am using SQL SERVER ON AZURE VIRTUAL MACHINE

Answer 1

@Muhammad Ahmer Ralisam yunnahs

Thank you for reaching out.

You can use Azure Data Factory to achieve database replication between subscriptions.

In your Azure Data Factory, create linked services for both the source and target database and configure the connection strings for each linked service.

Create a Data pipeline in Azure Data Factory.

Define the source (your Development database) and the sink (the target database in the other subscription). You will have the option to specify the frequency of data movement (e.g., daily, hourly). Set up any transformations or data mapping required during the copy process.

Trigger the pipeline manually or schedule it to run automatically.

Please do also refer to the Microsoft Official documentation.

https://learn.microsoft.com/en-us/azure/data-factory/quickstart-hello-world-copy-data-tool

Please comment below if you need more assistance.

Regards,

Oury