Open ITSM Hub
Deutsch

OTRSCloneDB

Free

by Znuny GmbHcompany

Tool to clone or migrate an OTRS/Znuny database to a different RDBMS (e.g., MySQL to PostgreSQL).

OTRSCloneDB is an essential administrative tool for OTRS and Znuny environments. It enables the migration of the entire database from one database management system (RDBMS) to another, such as moving from MySQL to PostgreSQL. The package handles the schema creation on the target system and transfers all data while maintaining integrity, including attachments and history data. The process is securely managed via the command line using the 'Maint::Database::Clone' command.

Features

  • Cross-Platform Migration

    Enables migration between different database backends such as MySQL, PostgreSQL, Oracle, and MSSQL.

  • Schema Automation

    Automatically creates the required table structures in the target database based on the source schema.

  • Console Integration

    Provides a command-line interface via the OTRS/Znuny console for reliable execution of large data volumes.

Categories

migrationDatabasemysqlpostgresqloraclemssqlcloneAdministration

Related packages

AdminTemplateCopy

Adds a "copy" link to the template management in the admin area.

ZnunyOTRS Community Edition
Free

CLARIN-D Helpdesk OTRS Extension

by Hamburger Zentrum für Sprachkorpora (HZSK)

A collection of custom OTRS modules, configurations, and scripts for the CLARIN-D helpdesk, featuring a SOAP API, a PHP form, and R statistics.

OTRS Community EditionZnuny
Free

ERSchema

Adds a visualization of the database schema as an Entity-Relationship (ER) diagram directly within the administrative interface.

ZnunyOTOBOOTRS Community Edition
Free