CloudM Migrate 4.4 replaces Microsoft SQL Server with PostgreSQL. During the upgrade, existing CloudM Migrate data will be migrated automatically. Below are the upgrade paths for both single-server and multi-server environments.
This article focuses on upgrading an existing CloudM Migrate installation. For guidance on setting up a new CloudM Migrate environment, please refer to the relevant documentation here.
Hosted Upgrade
Migrate Hosted instances will be automatically updated to Migrate 4.4 upon rebooting after a period of 2 hours of inactivity.
During the update, existing Microsoft SQL Server data will be migrated to PostgreSQL. As a result, startup may take slightly longer than usual. Users will be notified of this on the loading screen when logging back into Migrate Hosted.
Self-Hosted Single-Server Upgrade Paths
It is important to note that in cases where PostgreSQL needs to be installed and the existing Microsoft SQL server databases need to be migrated, this can take some time (in some cases, it can exceed 15 minutes).
1. SQL Server Express Installed During Initial Installation
-
PostgreSQL will be installed on the same server.
-
CloudM Migrate data will be moved from Microsoft SQL Server to PostgreSQL.
2. Customer-Provided SQL Server Express Instance
-
PostgreSQL will be installed on the same server.
-
CloudM Migrate data will be migrated automatically.
-
No need to specify credentials. Existing connection strings will be used.
3. Full SQL Server Instance
-
PostgreSQL will be installed on the same server.
-
CloudM Migrate data will be migrated automatically.
-
No need to specify credentials. Existing connection strings will be used.
4. Customer-Installed PostgreSQL Instance
-
The installer allows selection of an existing PostgreSQL instance.
-
Data from the currently connected Microsoft SQL Server will be migrated.
-
Warning: Any databases with the same name in the existing PostgreSQL instance will be overwritten.
Self-Hosted Multi-Server Upgrade Paths
1. SQL Server Express on Primary Server (Installed During Initial Installation)
-
PostgreSQL will be installed on the same primary server.
-
CloudM Migrate data will be migrated automatically.
-
Secondary servers must be upgraded separately.
2. Customer-Provided SQL Server Express on Primary Server
-
PostgreSQL will be installed on the same primary server.
-
CloudM Migrate data will be migrated automatically.
-
No need to specify credentials. Existing connection strings will be used.
-
Secondary servers must be upgraded separately.
3. Full SQL Server Instance on Primary Server (Customer-Provided)
-
PostgreSQL will be installed on the same primary server.
-
CloudM Migrate data will be migrated automatically.
-
No need to specify credentials. Existing connection strings will be used.
-
Secondary servers must be upgraded separately.
4. Separate SQL Server Running SQL Express
-
CloudM Migrate data will be migrated to PostgreSQL.
-
No need to specify credentials. Existing connection strings will be used.
-
Secondary servers must be upgraded separately.
5. Separate SQL Server Running Full SQL
-
During installation, an existing PostgreSQL server can be selected.
-
CloudM Migrate data will be migrated to the specified PostgreSQL instance.
-
No need to specify credentials. Existing connection strings will be used.
-
Secondary servers must be upgraded separately.
6. Customer-Installed PostgreSQL on Primary Server
-
During installation, an existing PostgreSQL server can be selected.
-
CloudM Migrate data will be migrated to the specified PostgreSQL instance.
-
No need to specify credentials. Existing connection strings will be used.
-
Secondary servers must be upgraded separately.
7. Separate PostgreSQL Server
-
During installation, an existing PostgreSQL server can be selected.
-
CloudM Migrate data will be migrated to the specified PostgreSQL instance.
-
No need to specify credentials. Existing connection strings will be used.
-
Secondary servers must be upgraded separately.
-
Warning: Any databases with the same name in the existing PostgreSQL instance will be overwritten.