I am implementing a Dump routine from the PROD environment to another environment, using a 100% Azure setup. I need a solution that:
- Copies the database structure (tables, indexes, procedures, views, constraints, etc.).
- Replicates data only from specific tables, as we cannot copy sensitive data.
Is there an automated way to accomplish this in Azure?