Welcome > Azure setup > Import/export tenant specific databases

Import/export tenant specific databases

  1. Open the Azure Management portal.
  2. Click the Database option.
  3. To export tenant-specific database:
    1. Select the database that you want to move to the new database server.
    2. Click Export. The database is exported as a .bacpac file.
    3. Select a storage CONTAINER to which to export the .bacpac file.
    4. Click on Tick button to export the database.
    5. Rename the filename to be same as database name, that is, TotalAgility_<Tenant Code> format.
  4. Now import the .bacpac file to the destination database server:
    1. On the Main menu, click NEW.
    2. Select DATA SERVICES > SQL DATABASE > IMPORT.
    3. In the IMPORT DATABASE window, specify the database details stored in the storage during export.
    4. Click the Tick button.

      The database is imported.

      Note Make sure the imported database name is same as the exported tenant database. (TotalAgility_<Tenant Code> format)

      A message appears to confirm that the database is successfully imported.