Monitor G5 is moving to PostgreSQL. Here is what you need to do

Monitor is replacing the SQL Anywhere database with PostgreSQL. Version 27.2, due in February 2027, is planned to be the last with SQL Anywhere support. Your own reports, SQL queries and connections need reviewing before you switch.

What is changing

  • Monitor is replacing SQL Anywhere with PostgreSQL. PostgreSQL is required for future upgrades and continued support.
  • Version 27.2 (February 2027) is planned to be the last version with SQL Anywhere. From version 27.3 support is removed completely.
  • If you run Monitor in Monitor's cloud, Monitor handles the move. With a local installation you move yourselves using the PostgreSQL Assistant tool, which needs version 26.5 or later.
  • According to Monitor, the Monitor API is not affected by the switch.

What you are responsible for

According to Monitor, customers must review and test their own solutions that are not covered by an update agreement:

  • Your own SQL solutions: queries, views, procedures and external programs
  • Your own reports and document variants
  • Your own Power BI and Excel solutions over ODBC
  • Adaptations from Monitor without an update agreement, and solutions bought from consultants or third parties

Checklist before the switch

  1. List every report, SQL query, view and program of your own that reads from the Monitor database.
  2. List every Excel and Power BI file that fetches data over ODBC, and who uses it.
  3. Find out which adaptations you have that are not covered by an update agreement.
  4. Update Monitor to at least version 26.5 so the PostgreSQL Assistant works.
  5. Ask for a test company and test each solution against PostgreSQL before the real move.
  6. Start with what matters most to the business, such as reports used every day.

How we can help

We go through your own reports and connections, rewrite what needs to change for PostgreSQL and test it against a test company. It starts with a fixed-price pre-study, followed by a fixed quote for the rewrite itself. Where it fits, we can also move reports your customers need, such as order status or certificates, to a web portal that reads through Monitor's API.

This guide is based on Monitor's own information about the switch, read on 21 November 2026. Codefors is not a Monitor ERP partner. Always check the current dates with Monitor: Monitor's page about the switch to PostgreSQL