Changes
Jump to navigation
Jump to search
← Older edit
Newer edit →
FAQ Migrate my Mysql database to PostgreSQL
(view source)
Revision as of 20:09, 14 January 2019
345 bytes added
,
5 years ago
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>
Delcroip
41
edits
Navigation menu
Personal tools
Create account
Log in
Namespaces
Page
Discussion
Variants
Views
Read
View source
View history
More
Search
Navigation
Main page
Recent changes
Tools
Printable version
Social networks
Facebook
LinkedIn
Twitter
Youtube