Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Backups that are exported through the UI are in CSV format. As said in the parent page Import/export of Requirement Yogi data to a Confluence or Jira instance, backups can be used to export the entire Requirement Yogi data of a space and reimport it to another space or instance.

...

  • Name of the table (plain data is kept in DBBackupItem, mappings are in DBBackupMapping),

  • Name of the target table,

  • Old ID: ID in the old system. In this example, it’s the ID of DBRemoteRequirement. During reimport, the creation of the record will generate a fresh ID, which is written in DBBackupItem.NEWID, just to keep an archive of what has been migrated (and eventually perform mappings).

  • Then all columns of the table. The order is specified by the annotation @ExportMapping(order = 2) on each column in the code.

The detail of the structure of each table is visible on those two pages:

Second half of the files

It contains the “mappings”, i.e. the list of Confluence or Jira entities that we rely on. For example, it could contain the details of a space. During reimport, mappings are loaded in the table DBBackupMapping, and the system administrator can remap a space key to another; During the reimport, every time we reference this space, we’ll take the new key instead of the old one.

...