On Wed, 11 Dec 2013, mikael.schm...@ixx.se wrote: > Is it possible to migrate from postgresql to mysql and be able to > preserve all information? I haven't been able to find any > documentation/howto's on this. We need to run mysql in order to get > the reporting module to work
I've not been able to find anything non-commercial to migrate data from one to the other, either, and I have a desire to take things the other way. Ultimately, what you'll probably need to do is write a routine (e.g. in Perl) that extracts stuff from the PostgreSQL database row by row, table by table, and which writes the same rows into the MySQL database using the MySQL schema. Depending on the column- types there may be some soft massaging of formats to get from one to the other, but those are likely minor and will probably be in the time/date-based realm. It's a pain, but once you have the routine coded it'll be useful for other things -- especially if the main database engine is to remain PostgreSQL and you just want to extract the data into MySQL for the reporting aspect. +------------------------------------------------+---------------------+ | Carl Richard Friend (UNIX Sysadmin) | West Boylston | | Minicomputer Collector / Enthusiast | Massachusetts, USA | | mailto:crfri...@rcn.com +---------------------+ | http://users.rcn.com/crfriend/museum | ICBM: 42:22N 71:47W | +------------------------------------------------+---------------------+ ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ icinga-users mailing list icinga-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/icinga-users