While taking a backup for a Qualitia project, ensure that you backup Qualitia Automation Studio creates the following databases in the selected database management system (MySQL or SQL Server):

• A Master Database that serves as an anchor for all the projects.

• A Project Database for every project, which stores the associated project artifacts. Every Project Database is named as Projectname_projectdb.

• A Result Database for every project, which stores the results of all the test suite executions. Every Result Database is named as Projectname_resultdb.

Best Practices

Qualitia recommends the following best practices for project backup and restore.

• Integrate your project with a version control tool (SVN or Git).

• Backup the database, GIT/SVN, custom actions, and reports daily.

• Ensure that you perform the following actions while backing up a Qualitia project:

  • Back up the database, custom actions, reports, and SVN/GIT at the same time so that all the artifacts are in the same state and are synchronized with each other.

  • Ensure that no user is working while backing up the project.
    Tip: Stop the Qualitia license server temporarily to stop the users from using Qualitia.

  • Backup the constraints and triggers for the following databases:

    • Master Database

    • Project Database

    • Reports Database

  • Backup the Results folder from the Qualitia Server, which stores the Realtime Reporting data.

  • If you do not use a version control tool, ensure that you back up the following folders for every project:

    • Project Path, which stores the test cases and tasks as XML files.

    • Custom Action Repository Path, which stores the custom actions.
      Note: To know the location of these folders, click Settings >Project Settings. The location of these folders might differ for every project.

  • Backup ​the TFS folders from Qualitia Server for the projects that are integrated with the TFS/Azure DevOps projects

• Similarly, while restoring a Qualitia

...

• project, ensure that you restore the constraints and triggers for the following databases:

  • Master Database

  • Project Database

  • Reports Database
    Note: If you restore a project without

...

• • restoring its constraints and triggers, then

...

• • after the project is restored

...

• • , the object creation fails.

• Before upgrading the Qualitia Automation Studio to a higher version, backup all the projects and follow all the best practices recommended for backing up and restoring the projects.