topic Re: From Alfresco 4.0x Windows Server 8 to Alfresco 4. 2c Centos 6.2 in Alfresco Archive

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

tribexa — Tue, 22 Jan 2013 15:32:45 GMT

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.

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

bisana — Thu, 24 Jan 2013 05:54:16 GMT

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

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

mrogers — Thu, 24 Jan 2013 17:30:25 GMT

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.

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

nikes — Mon, 28 Jan 2013 08:54:46 GMT

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.

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

heiko_robert — Mon, 28 Jan 2013 09:33:56 GMT

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.