topic Re: Postgress to MySql database migration issue. in Alfresco Archive

Postgress to MySql database migration issue.

aditya_chaudhar — Wed, 01 Apr 2015 11:43:50 GMT

Hi Everyone ,I have installed default alfresco on production and created site,LDAP,Kerberos and other customization.But now i have task to migrate from postgress DB to MySql.what i did :1. installed MySql and change some properties in alfresco-global.properties using below link(http://docs.alfresco.

Re: Postgress to MySql database migration issue.

mrogers — Wed, 01 Apr 2015 12:28:03 GMT

You have forgotten the important step of migrating the database!

http://stackoverflow.com/questions/5909223/migrate-database-from-postgres-to-mysql

Re: Postgress to MySql database migration issue.

aditya_chaudhar — Thu, 09 Apr 2015 07:08:57 GMT

Thanks a lot mrogers for your quick help ,

I follow link you mentioned.i convert pstgress data to mysql format. and copy all alf_data and rebuild solr index it was working good on test level.

But as it was possible for us to have fresh installation with MySql on production we go with that.

below link helps me to install mysql with alfresco
https://sudheerreddyduganapalli.wordpress.com/2014/05/21/alfresco-community-4-2-b-installation-with-mysql-database-for-windows/

Thank you for your quick reply

Thanks and Regards
Aditya Chaudhari