From 1.013 with sqlite to 1.20 with mysql

Started by tivanni, May 10, 2012, 05:04:16 PM

Previous topic - Next topic

tivanni

Hi,
i'd like to migrate my netxms from version 1.013 with sqlite to 1.20 with mysql.
To make this, i think of follow this procedure:
1)export sqlite database
2)convert to mysql
3)bind netxms 1.013 with new mysql database
4)upgrade to 1.20

Can this work?Any suggest or esxperiences?Is there a quick way to convert database from sqlite to mysql?
Thank you in advance for help

Victor Kirhenshtein

Hi!

This should work. In fact, export data file is an sqlite database, so you can try to create new mysql database and use your SQLite database file as source for nxdbmgr import.

Best regards,
Victor