How to identify and change the current database of M365 Manager Plus
M365 Manager Plus by default comes bundled with PostgreSQL database. If required, you can migrate to MS SQL. This article elaborates the steps to identify the current database of M365 Manager Plus and migrate data from PostgreSQL to MS SQL.
Steps to identify the current database of M365 Manager Plus
- Go to the <product_installation_directory>/conf folder.
- Open the database_params file.
- The current database details can be found in the URL section of the file. Refer the image below.
- In the above image, the line url=jdbc:postgresql://localhost:33365/m365 gives the database details, which is PostgreSQL in this case.
Note: In short the, general format is url=jdbc:subprotocol:DataSourceName, where the subprotocol gives the database details.
Steps to migrate M365 Manager Plus from PostgreSQL to MS SQL.
To migrate from PostgreSQL to MS SQL, please follow the steps provided in this document.