31,003
edits
FAQ Migrate my Mysql database to PostgreSQL: Difference between revisions
Jump to navigation
Jump to search
FAQ Migrate my Mysql database to PostgreSQL (view source)
Revision as of 16:05, 13 May 2012
, 14 years ago→Prerequisite
| Line 3: | Line 3: | ||
= Prerequisite= | = Prerequisite= | ||
Your Dolibarr version must be at least version 3.2.0. | Your Dolibarr version must be at least version 3.2.0. | ||
If not, first upgrade your Dolibarr keeping | If not, first upgrade your Dolibarr keeping MySq. Once upgrade is ok, you must clean database from old tables by running following request on your Mysql database: | ||
<source lang="sql"> | |||
DROP TABLE llx_c_methode_commande_fournisseur; | |||
DROP TABLE llx_c_source; | |||
DROP TABLE llx_cond_reglement; | |||
DROP TABLE llx_expedition_methode; | |||
DROP TABLE llx_product_fournisseur; | |||
ALTER TABLE llx_product_fournisseur_price DROP COLUMN fk_product_fournisseur; | |||
</source> | |||
=Process= | =Process= | ||