Operational Defect Database
BugZero found this defect 503 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Veeam | kb4409
How to Migrate Veeam Backup Enterprise Manager's Database from Microsoft SQL to PostgreSQL
Last update date:
1/5/2024
Affected products:
Veeam Backup & Replication
Affected releases:
12.1
Fixed releases:
No fixed releases provided.
Description:
Purpose
This article documents migrating the Veeam Backup Enterprise Manager (Enterprise Manager) configuration database from Microsoft SQL to PostgreSQL. Notes: The migration process is one-way only. Migration can only be performed from Microsoft SQL to PostgreSQL. The database engine used by the Veeam Backup Enterprise Manager and all of the Veeam Backup & Replication Servers managed by that Veeam Backup Enterprise Manager must match. Any mismatch in the database engine will cause the Database Replication task to fail with either: Veeam Backup Enterprise Manager with Microsoft SQL Server configuration database does not support the management of backup servers using PostgreSQL. or Veeam Backup Enterprise Manager with PostgreSQL configuration database does not support the management of backup servers using Microsoft SQL Server. Migration from Microsoft SQL to PostgreSQL is only possible for Veeam Backup Enterprise Manager running version 12 or newer.
Requirements
This procedure requires the following: The Veeam Backup Enterprise Manager database must presently be using Microsoft SQL. An existing PostgreSQL instance must be available for the database to be moved to, either local to the Veeam Backup Enterprise Manager software or remote.
Solution
Part 1: Back up the Current Veeam Backup Enterprise Manager Database Open an Administrative Command Prompt Navigate to the Veeam Backup Enterprise Manager install folder:
