FAQ Migrate my Mysql database to PostgreSQL: Difference between revisions

Note that you can run this import several time if you fixed error manually to your structure. It is safe because all dolibarr tables are protected by a "unique key". So if you do so, you will just get "duplicate record" errors, that you can ignore. Take care only on others.

* Once import is finished, you must enable constraint check and update all sequences to match imported data.

psql -h name_or_ip_of_postgresql_server -d name_database_postgresql -U login_database_mysql

> select dol_util_triggerall(true);