Restore database from one Pool to another Pool RRS feed

  • Question

  • I have two SQL Elastic Pools.  One for production and a second for QA.

    I would really like to be able to export a database from the Production SQL Elastic Pool, then import it into the QA SQL Elastic pool.

    I am able to export the database, then I'm able to import it into the server running the QA pool under a different name.

    I want to import it with the same name as the QA database and have it use the QA Shard Id, but it does not look like it will be easy.

    Has anyone done anything like this?

    Brandon Schenz

    Tuesday, June 21, 2016 5:56 PM

All replies