0

We have two Azure PaaS SQL Servers, one in our production resource group and another in our QA resource group.

I'm looking for the best way to 'copy' the data from an Azure SQL DB in the production resource group to an Azure SQL DB in the QA resource group. As part of this process the data must undergo some simple transformations to anonymise the data before it lands in the QA DB.

We have deletion locks in place on the resource groups so deleting and recreating databases is an option I'd rather avoid.

The 'copying' can take place on a weekly schedule and it would be acceptable to drop any existing data in the target Azure SQL DB each time the process is run.

What are the most suitable options in Azure to accomplish this?

Improve this question
2
  • How did you want to deal with the data? Please try Data Factory Data Flow, it have many functions and support expression, it can help you achieve that. Commented Aug 21, 2020 at 3:10
  • Hi @TonE, do you have any other concerns? Please feel free to let me know. Commented Aug 24, 2020 at 1:42

1 Answer 1

Reset to default
1

Go with Azure Data Factory. You can use it for pretty much anything that SSIS was used for onsite, and more.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.