Welcome > Transfer the tenant's database manually

Transfer the tenant's database manually

To transfer the tenant's database manually, first export the database and then import the database into the destination location.

  1. Open the Windows Azure Management portal.
  2. Select the database to move to the new database server and click Export.
  3. In the Export Database Settings window, select the BLOB STORAGE ACCOUNT and CONTAINER.
  4. Enter the database login credentials such as username and password, and click Ok.

    The database is created as .bacpac file in the specified container.

    Note Rename the filename similar to the database name, for example, TotalAgility_<Tenant Code>.
  5. To import the database in the destination location, click New > DATA SERVICES > SQL DATABASE > IMPORT.
  6. Select the .bacpac file and specify the destination database location.
  7. Enter the database details and click Ok.

    A message appears to indicate the import was successful.

    Important While updating the tenant's storage account, you must first download all the files from the current account and upload them to the new account. To perform this operation, you can use a Storage Management tool such as Clumsy Leaf Software's CloudXplorer.