Export the database to Bacpac file

🚧

Prerequisite

• An Optimizely cloud account to access the self-services for Optimizely DXP. See Creating an Optimizely Cloud Account.
• A provisioned project on DXP.

You can export the Optimizely Content Management System (CMS) or Optimizely Commerce (PaaS) database to a bacpac file using the API or the DXP Management Portal.

When you export a database, it triggers an export job for the requested database. The export job copies the requested database from the requested environment to a database in the Integration environment to avoid performance issues in the production environment when the export runs. After this, it exports to a bacpac file from the copied database, and stores the bacpac on BLOB storage.

📘

Note

The Export Database process can take from a few hours to several days (in extreme cases). You can export only one database at a time.

Export the database

1. Select your project on the home page.

2. On the project detail page, open the Troubleshoot tab.

   

3. Scroll to the Export Database section, select an Environment, Database, and Retention Hours, then click Export.

   📘

   Note

   Retention hours specify how long the export is available before it is removed.

4. A confirmation dialog box displays. Click OK to start the export database progress. The progress result displays in real-time, and the export database file shows when the export database progress finishes.

   

   • Available Database Files – If available, click a database file link to download the database file to your local machine.

     📘

     Note

     You can download the exported database file only when is not expired.

   • Expired Database Files – Click Show/Hide to display or hide exported files that have expired within the last seven days.