NetXMS Wiki

Difference between revisions of "How to migrate to another database"

How to migrate to another database (view source)

Revision as of 18:13, 13 September 2022

167 bytes removed ,  18:13, 13 September 2022
m
Text replacement - "^" to "{{deprecated}}"
m (Text replacement - "^" to "{{deprecated}}")
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
NetXMS database manager (nxdbmgr) provides database migration option. To perform database migration follow these steps:
{{deprecated}}NetXMS database manager (nxdbmgr) provides database migration option. To perform database migration follow these steps:


1. Create a copy of existing '''netxmsd.conf''' ('''netxmsd_old.conf''' in this example).
1. Create a copy of existing '''netxmsd.conf''' ('''netxmsd_old.conf''' in this example).
Line 5: Line 5:
2. Create new database.
2. Create new database.


3. Initialize new database:
3. Adjust '''netxmsd.conf''' - change DBDriver, DBName, etc. to match new database.


  nxdbmgr init /opt/netxms/share/netxms/sql/dbinit_pgsql.sql
4. Initialize new database:


Please note, that there are different files for different database types, in this example - '''dbinit_pgsql.sql''' is for PostgreSQL.
  nxdbmgr init
 
4. Adjust '''netxmsd.conf''' - change DBDriver, DBName, etc. to match new database.


5. (optional) Run "nxdbmgr check" to verify connectivity to new database.
5. (optional) Run "nxdbmgr check" to verify connectivity to new database.
Retrieved from "https://wiki.netxms.org/wiki/Special:MobileDiff/1427...1814"