Database Migration from MySql to MSSQL 2005

[csvalavan]

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.

[wonn1377]

Data loader can help u,it can migrate almost any data, it helps me to convert MySQL to MSSQL, MS access to MSSQL, mysql, csv  loader, foxpro and MSSQL to MS access, MYSQl, CSV, foxpro etc. i found it on google search.


Download Free : http://www.dbload.com

[groutal]

What you can use is an ETL tool. There are open source tools available for free.

Talend Open Studio is an open source ETL tool for data integration and migration experts. It's easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component. It allows the user to get a graphical and functional view of integration processes.

Talend has components for MySql and MsSql, so you'll be able to migrate the data.

For more information: http://www.talend.com/

[jean3167]

Here is a tool to convert MSSQL database. That i found on google search it this converter can do migrate any data try and tel me is that worth or not.

[dmsoft]

Hello,

Try db conversion tool from http://dbconvert.com/convert-mssql-to-mysql-pro.php