27,414
edits
Changes
Jump to navigation
Jump to search
Line 62:
Line 62: − +
FAQ Migrate my Mysql database to PostgreSQL (view source)
Revision as of 16:33, 13 May 2012
, 11 years ago→Import dump file
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.
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.
* Once import is finished, you must enable constraint check and update all sequences to match imported data.
<source lang="bash">
<source lang="sql">
psql -h name_or_ip_of_postgresql_server -d name_database_postgresql -U login_database_mysql
psql -h name_or_ip_of_postgresql_server -d name_database_postgresql -U login_database_mysql
> select dol_util_triggerall(true);
> select dol_util_triggerall(true);