Prod to Q/A on Private Cloud w/ Azure SQL?

0
I'm trying to take a snapshot/copy of my production environment to use to update my Q/A-Stage environment.  I am on Azure using Azure SQL.  I've seen the docs relating to using the Migrate Data tool for private cloud, but that only supports PostgreSQL. Does anyone have any experience doing something like making a backup my production Azure SQL database and restoring it to another environment?  Will this work without other updates or are there settings in the copied database that need to be updated to reflect the new environment?
asked
1 answers
1

Hi Tim, you can copy your production Azure SQL database to your QA or Stage environment, even though Mendix Migrate Data tool only supports PostgreSQL.

 

1. Export Production DB Use Azure Portal or SSMS (SQL Server Management Studio) to export the database as a .bacpac file.

2. Import to QA, restore the .bacpac file into your QA Azure SQL instance using Azure Portal or SSMS.

 

After Restore – Mendix-Specific Checks:

1. Update environment-specific settings adjust constants, URLs, and any configuration stored in the DB.

2. Disable Scheduled Events prevent background jobs or integrations from running on QA by disabling or mocking them.

3. Clear sensitive data remove API tokens, user sessions, or any confidential info that shouldn’t exist in QA.

 

Note: You can safely restore your Azure SQL production DB to QA, but be sure to update settings and disable sensitive processes after import. This ensures your staging environment is clean, safe, and stable.

 

I hope this one helps you! :)

answered