NetXMS Support Forum

Hi, is "nxdbmgr.exe export" supposed to work with other databases than SQLite? I'm using PostgreSQL and I get


C:\NetXMS\bin>nxdbmgr.exe export DBbackup
NetXMS Database Manager Version 1.2.7

ERROR: Schema version mismatch between dbschema_sqlite.sql and your database. Please check that NetXMS server installed correctly.
Database export failed.


Shouldn't dbschema_pgsql.sql be used?
I'm running NetXMS 1.2.7 on Windows7 with PostgreSQL 9.2.

Hi!

Export file is in fact SQLite database, and file dbschema_sqlite.sql used to create empty export file. Looks like installer contains wrong version of this file. Find schema files and replace them with attached, then export should work.

Best regards,
Victor

After replacing files in C:\NetXMS\lib\sql by your files, export works.
Thank you very much.