OTRS 5 migration from MySQL to PostgreSQL
Edson Richter <[email protected]> Tue, 19 Feb 2019 22:13:00 +0000
| Newsgroups | gmane.comp.otrs.user |
|---|---|
| Message-ID | <MN2PR01MB53277B9A435E414041E584C9CF7C0@MN2PR01MB5327.prod.exchangelabs.com> |
Our company uses PostgreSQL as standard database for everything (that needs one 😉 ). So, our OTRS 5 system is the last one based on MySQL. Since we are facing some OS update issues, we decided it is time to move. I would like to know if there is a easy way to migrate data: for instance, can I bakcup (using otrs backup/restore scripts) on MySQL and restore on PostgreSQL? Or can you point me the tables that are more critical? I’ve tried to migrate using pgLoader (it is a breeze), but some contente show strange caracters after migration. I’ll appreciate your guidance or share your experience! Atenciosamente, Edson Richter Soli Deo Gloria --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs