Restore Azure SQL Database from Another Azure SQL Database

Question

I'm not sure if this question has been asked because it's possible that I don't know how to ask the questino properly, but here goes...

I have two Azure SQL Databases. One is for testing and one is for production. In my CI/CD process, I would like to be able to take a copy of production (database) and restore it on top of the testing database. Everything I've read explains how to delete the existing database and restore a dacpac file in it's place. I don't want to do that because it's difficult as it is to create SQL user accounts and set permissions on them, so I would prefer to simply restore on top of the testing database. Is that possible with Azure SQL Databases? If so, could someone please enlighten me?

Alberto Morillo · Accepted Answer · 2019-01-31 19:58:33Z

2

No. It is not possible. If you restore from a bacpac or restore from automated backups it will always create a new database as result of the restore. Have you tried to create your test database using CREATE DATABASE AS COPY OF?

DROP DATABASE MyTestDB;
CREATE DATABASE MyTestDB AS COPY OF MyProdDB;

answered Jan 31, 2019 at 19:58

Alberto Morillo

15.8k3 gold badges29 silver badges32 bronze badges

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

1 Comment

clockwiseq Over a year ago

Absolutely cannot believe it was as easy as that. WOW! Thank you so much for the quick fix. This really did make my day.

Collectives™ on Stack Overflow

Restore Azure SQL Database from Another Azure SQL Database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related