Loading...
Loading...
This article documents the migration of 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. [Note: Starting in Veeam Backup & Replication 13, this limitation was removed, allowing Veeam Backup Enterprise Manager and the Veeam Backup & Replication deployments it manages to operate different database engines.] For all builds of Veeam Backup & Replication 12.x, 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.
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.
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:
Veeam Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.