Planmeca/romexis-server-docker
Private
Public Access
5
1
Packages Wiki
Page: Backup and Restore
Pages
Architecture.de Architecture Backup and Restore.de Backup and Restore Base Image.de Base Image Build System.de Build System CI CD Pipeline.de CI CD Pipeline Compose Runtime.de Compose Runtime Configuration.de Configuration Container Images.de Container Images Database Backends.de Database Backends Developer Guide.de Developer Guide Docker Desktop WSL Windows.de Docker Desktop WSL Windows FAQ.de FAQ Firebird.de Firebird Home.de Home Java Property Agent.de Java Property Agent Local Build Scripts.de Local Build Scripts Microsoft SQL Server.de Microsoft SQL Server Migration Client.de Migration Client Migration Service.de Migration Service Migration Workflow.de Migration Workflow Payload Images.de Payload Images Project Overview.de Project Overview Project Structure.de Project Structure Quick Start.de Quick Start Reference BUILD.de Reference BUILD Reference DEVELOPERS.de Reference DEVELOPERS Reference MIGRATION_README.de Reference MIGRATION_README Reference MIGRATION_WORKFLOW.de Reference MIGRATION_WORKFLOW Reference README compose.de Reference README compose Reference README.de Reference README Release Process.de Release Process Romexis Admin.de Romexis Admin Romexis Client.de Romexis Client Runtime Layout.de Runtime Layout Security.de Security Server Image.de Server Image Source README References.de Source README References Synology ContainerStation.de Synology ContainerStation Troubleshooting.de Troubleshooting mRomexis WebApp.de mRomexis WebApp
Clone
3
Backup and Restore
Patrick Gniza edited this page 2026-08-17 10:48:39 +02:00
Table of Contents

Deutsch | English

Backup and Restore

MSSQL Backup Restore

The migration service restores SQL Server backups through the shared backup directory.

Host:

DATABASE_BACKUP_DIR=/srv/mssql-backup

Migration service:

/upload/database

SQL Server:

/var/opt/mssql/backup

Restore scripts should use the shared path so SQL Server can access the uploaded .bak file.

Firebird Backup Restore

Firebird support includes original helper scripts from the macOS installer payload:

/opt/romexis-firebird-db/tools/Romexis_Firebird_Backup.sh
/opt/romexis-firebird-db/tools/Romexis_Firebird_Restore.sh

Long-term restore strategy should support:

.fbk backup restore through gbak
.fdb file handling for compatible database files

For migrations, gbak-based restore is preferable because it can bridge Firebird ODS/version differences more safely than copying raw .fdb files.

Restart After Restore

The migration service should not directly manipulate the Romexis process from the outside.

Instead, it uses the shared restart state file:

/data/romexis_images/.romexis_restart_state

Expected pattern:

  1. migration service writes restart request
  2. Romexis container notices request
  3. Romexis process is restarted
  4. Romexis container writes result
  5. migration service reads result
  6. migration service removes state file

Final Migration Completion

A completed migration should:

  • preserve logs
  • remove temporary SFTP user
  • hide action buttons
  • retain migration state for audit/debugging

Romexis Docker Wiki

English · Deutsch

English

Getting Started

Runtime Services

Build System

Database

Migration

Development

Source Documents

Deutsch

Erste Schritte

Runtime-Dienste

Build-System

Datenbank

Migration

Entwicklung

Quelldokumente

Romexis Docker Project Wiki / Romexis-Docker-Projekt-Wiki

English Home · Deutsche Startseite · English source documents · Deutsche Quelldokumente · Security · Sicherheit

Internal operations and development wiki / Internes Betriebs- und Entwicklungswiki