Migration database

[pav]

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

[victor]

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

[pav]

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>

[victor]

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

[pav]

It is helpfull,
thank you very much.

Pavel