Export ALM/QC projects

This section explains how to export a project from ALM/QC to files.

Overview

Consider the following before exporting ALM/QC projects:

  • Each ALM/QC project is composed of the database schema and file repository folder.

  • You can export the project to compressed files in the .qcp format or export the project into two separate files, one for the database schema dump or backup and the other for the file repository.

  • The exported files will be uploaded to a dedicated AWS S3 bucket. The location and credentials of the bucket will be provided during the migration process.

Back to top

Prerequisites

Ensure the following before exporting an ALM/QC project:

No checked-out entities in your project If your project enables version control, ensure there are no checked-out entities in your project. Projects with checked-out entities cannot be upgraded. If any checkouts are found during the upgrade process, un-checkout them in order to proceed.
DB schema and file repository are synched The database schema and file repository of your project are aligned. The best practice is to deactivate the project before exporting it.
S3 Browser client In order to accessing the AWS S3 Bucket.
Direct access to the ALM/QC database Make sure you have direct access to the ALM/QC database.
FTP client In case FTP will be used, for example, Windows FTP command-line client, or preferably the FileZilla FTP client.
MD5 software

For example, md5.

This is optional if the file sizes are the same after the upload.

ZIP software For example, 7-zip.
Backup of your ALM/QC instance Ensure a full backup of your ALM/QC instance.
Sanity check in the project to export

Run a sanity check in the project you want to export:

  1. Open ALM Site Administration.

  2. Right-click the project and select Maintain Project > Verify Project.

  3. If there is an error, fix it by running the Repair Project tool.

    To run the tool, right-click the project and select Maintain Project > Repair Project.

    If the error cannot be fixed, contact your site administrator.

Back to top

Export a project to a .qcp file

It is recommended that you export your project to a .qcp file. The file contains both the database schema and file repository. This method is faster if the database type is SQL server.

Note: For ALM 12.53 and earlier, there is a project size limit of 2 GB. For ALM 12.55 and later, there is no size limit. If your project is bigger than 2 GB, see Export a project to separate files.

To export a project to a .qcp file:

To export manually from the Site Administration See Export a project.
To use self-developed tools with ALM REST API

See the ALM REST API.

Note: This API is available to ALM 15.00 and later.

Back to top

Export a project to separate files

If your project is bigger than the size limit of 2 GB, you can export the project database schemas and file repository into separate files.

To export database schemas:

To export file repository:

  1. Open ALM Site Administration.

  2. Select the project you want to migrate. In the Project Details tab, under the Project Directory field, find the file repository path of the project.

  3. Connect to the application server, navigate to the project directory path, and compress the entire file repository folder.

  4. Run md5 sum.

    1. Open a command window, navigate to the location where the md5.zip file was extracted, and run the following command:

      Copy code
      md5.exe -generate <compressed folder path><compressed folder name.zip>

      For example,

      Copy code
      md5.exe – generate C:\”Documents and Settings”\Desktop\ project1_filereposiotry.zip

      The command returns the md5sum output. For example, 24BCED0C939DD7E61C6E4CCE252687BE project1_filereposiotry.zip

    2. Copy the output to a text file.

    3. Upload the following files to the AWS S3 bucket:

      • <project_filereposiotry>.zip

      • <project_filereposiotry_md5>.txt

  5. Repeat the above steps for each project you want to migrate.

  6. Compress the folder for every project in the .zip format and upload the file to the AWS S3 bucket.

Back to top

Summary

After you complete exporting a project, all the project data is saved in the following files:

Database
  • Oracle

    • A single file that includes the schema list, tablespaces, and size of each .dmp file.

    • All the schema dump files in the compressed format.

    • All the log files of the export.

  • MS SQL Server

    • All .bak files.

Repository All the file repositories in the compressed format.

Back to top

See also: