AutoPatrol, Bureaucrats, Administrators
683
edits
Difference between revisions of "How to migrate to another database"
How to migrate to another database (view source)
Revision as of 09:34, 6 February 2017
, 09:34, 6 February 2017no edit summary
| 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. | ||
4. Initialize new database: | |||
nxdbmgr init /opt/netxms/share/netxms/sql/dbinit_pgsql.sql | nxdbmgr init /opt/netxms/share/netxms/sql/dbinit_pgsql.sql | ||
Please note, that there are different files for different database types, in this example - '''dbinit_pgsql.sql''' is for PostgreSQL. | Please note, that there are different files for different database types, in this example - '''dbinit_pgsql.sql''' is for PostgreSQL. | ||
5. (optional) Run "nxdbmgr check" to verify connectivity to new database. | 5. (optional) Run "nxdbmgr check" to verify connectivity to new database. | ||