On 2015-12-23 16:07, [email protected] wrote: > Hello List, > > we would like to migrate all the address books and schedules from a sogo1 > server (pretty old installation with postgres backend an a CentOS 5 server) to > a sogo2 ubuntu server with a mysql backend. We cannot create a database dump > from the first installation due to a different database, and I suppose that > also the underlying schema changed between sogo1 and sogo2. > > Do you have any suggestions how we could migrate the sogo1 data to our new > server ? > > Thank you very much for you help in advance > Julian >
pg_dump can create standard conforming SQL dump that are importable into MySQL (--column-inserts); the SOGo installation manual has step-by-step instructions on how to update the schema to the current version after importing it into mysql (section "upgrading", work your way up on that list starting from your old version). -- Mit freundlichen Grüßen, / Best Regards, Sven Schwedas Systemadministrator TAO Beratungs- und Management GmbH | Lendplatz 45 | A - 8020 Graz Mail/XMPP: [email protected] | +43 (0)680 301 7167 http://software.tao.at
signature.asc
Description: OpenPGP digital signature
