Text only | Text with Images

NetXMS Support Forum

English Support => General Support => Topic started by: pav on July 31, 2013, 04:04:05 PM

Title: Migration database
Post by: pav on July 31, 2013, 04:04:05 PM
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
Title: Re: Migration database
Post by: Victor Kirhenshtein on July 31, 2013, 05:25:39 PM
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
Title: Re: Migration database
Post by: pav on July 31, 2013, 06:42:23 PM
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>
Title: Re: Migration database
Post by: Victor Kirhenshtein on August 01, 2013, 12:52:40 AM
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
Title: Re: Migration database
Post by: pav on August 01, 2013, 04:19:16 PM
It is helpfull,
thank you very much.

Pavel
Text only | Text with Images