NetXMS Support Forum

Hello,
is it possible migration database from SQLite to PostgresSQL?
I have about 700 nods and I can not configure the database again.

Thanks for the answer
Pavel

Hi!

Yes, it's possible. You can try to create empty database on PostgreSQL, change netxmsd.conf to use pgsql driver and new database, and then run

nxdbmgr import your_sql_database_file

Best regards,
Victor

Thanks.
I can't create backup database

C:\NetXMS\bin>nxdbmgr.exe export backup_db
NetXMS Database Manager Version 1.2.8

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

C:\NetXMS\bin>

Export file is in fact SQLite database. As you already have SQLite database, you can try import using your database file as input without doing export.

Best regards,
Victor

It is helpfull,
thank you very much.

Pavel