41
edits
FAQ Migrate my Mysql database to PostgreSQL: Difference between revisions
FAQ Migrate my Mysql database to PostgreSQL (view source)
Revision as of 20:09, 14 January 2019
, 7 years agono edit summary
No 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> | |||