Monitor switches to PostgreSQL as database manager
SQL Anywhere nearing the end of its lifecycle.
Monitor moves over to PostgreSQL as database manager
SQL Anywhere is nearing the end of its life cycle. As a result, Monitor will replace SQL Anywhere with PostgreSQL, a powerful and flexible database manager, for future development and operation.
As a customer, this means your data needs to be migrated to the new database. We plan to complete the migration process in 2025 and 2026. You will be informed well in advance of your migration, and we will ensure that the process is as smooth as possible for your business. Monitor will also ensure any options and adaptations covered by an update agreement are compatible with PostgreSQL when the migration takes place.
To help you prepare, we've gathered some important information below. We recommend that you read this material to get a clear picture of what the change entails, and how you can prepare.
Frequently asked questions:
What happens if I haven't changed database managers and converted databases before the deadline?
We will end support for SQL Anywhere at a later stage. When this happens, it will no longer be possible to update Monitor if migration to PostgreSQL has not been carried out. The end date is not yet determined, but information will be provided well before we end support for SQL Anywhere.
Will the Monitor API be affected by the switch?
The Monitor API will not be affected by the transition from SQL Anywhere to PostgreSQL.
What applies to adaptations and integrations not covered by an update agreement?
As a customer, you are responsible for ensuring these are compatible with PostgreSQL when the integration takes place.
What is a custom adaptation or integration?
Below are examples of solutions for which you, as a customer, are responsible for ensuring compatibility with PostgreSQL.
• Custom SQL queries
• Custom document variants with SQL
• Customized reports
• Custom database views and procedures
• Custom Excel solutions via ODBC
• Custom Power BI solutions via ODBC
• Custom external programs with SQL
• Adaptations created by a Monitor consultant not covered by an update agreement