From Alfresco 4.0x Windows Server 8 to Alfresco 4. 2c Centos 6.2

[tribexa]

Hello.

We've been running community edition Alfresco 4.0d on Windows Server 8. We've now installed Alfresco 4.2c on Centos 6.2 and would like to transfer the database from 4.0d to 4.2c. Is this possible? Also, can we store the repository or data on external storage?

thanks, Tribexa.

[bisana]

Hi Trbexa
It depends
If u have used MSSQL, you have been a victim of Vendor locking.But if u was using MySQL or PostGRESQL then from windows to LINUX is possible and easy.
Please let us know what database u use

[mrogers]

Just be aware that there can be some minor differences in default values between *DOZE and *UX  In particular the collation order and character set. If you look in these forums you should find guidance.

[nikes]

Long back we faced issue when we did backup of MySQL database from Windows restored in Linux. It was due to CASE in which tables names are defined.

Windows and Linux might have respective default value (lowercase, uppercase) for table names, but it is configurable.

[heiko_robert]

Hi Tribexa,
yes it is (best) practice to switch to Linux. All of our customers did that to avoid the CIFS problems and to get better scalability and manageability.
As Nikes said: when you restore database backup on the Linux box you need either to configure your database case intensive (which I don't recommend) or you change your JBPM and ACT table names before starting alfresco.