backup – Azure SQL Database – Restore options for Continuous Integration Builds

admin

We have a Azure SQL Database (PAAS) that acts like a master database for testing new code.

The goal is to set up a pipeline that creates a writeable copy of the master database to test new builds continuously during the day. All the data in the database is needed to be able to perform tests.

Backup/Restore/Copy(?) is a too slow operation for this scenario since the database is too big.
Contaniners is not an option.

Is there any other smart way to create a writeable copy/snapshot of a Azure SQL Database?

Read more here: Source link