AnsweredAssumed Answered

Database Migration from MySql to MSSQL 2005

Question asked by csvalavan on Jan 22, 2009
Latest reply on Aug 31, 2009 by dmsoft
Hi:

I am using Alfresco 2.1 and the database is MySql. I need to migrate the database to MSSQL 2005. I would like to know the best method available.

I have tried the following methods and nothing is working out.

1)   Database and Repository restore - I have migrated data into SQL Server and have modified alfresco database properties, but while starting alfresco it fails by throwing this exception: java.lang.NullPointerException
        at org.alfresco.repo.domain.PropertyValue$ValueType.convert(PropertyValue.java:301)

2)   Export / Import Option from Alfresco  - Export works fine but import is failing. Also my application contains Web Projects, this option doesn't export Web projects as per the documentation.



Thanks,
Senthil.

Outcomes