41
edits
Changes
FAQ Migrate my Mysql database to PostgreSQL (view source)
Revision as of 20:09, 14 January 2019
, 6 years agono edit summary
Line 88:
Line 88:
You should now have an application 100% working with all its data.
You should now have an application 100% working with all its data.
Old MySql database can be closed.
Old MySql database can be closed.
+
+=Other solution: pgloader=
+In a single line of code the database can be migrated (tables are call dolibarr)
+https://github.com/dimitri/pgloader
+==Prerequisite==
+<source lang="bash">
+sudo apt-get install pgloader
+</source>
+
+==Process==
+<source lang="bash">
+ pgloader mysql://USER:PASSWORD@IP_MYSQL:3306/dolibarr postgresql:///dolibarr
+</source>