topic Re: Database Migration from MySql to MSSQL 2005 in Alfresco Archive

Database Migration from MySql to MSSQL 2005

csvalavan — Thu, 22 Jan 2009 09:36:16 GMT

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 modifi

Re: Database Migration from MySql to MSSQL 2005

wonn1377 — Tue, 25 Aug 2009 10:49:46 GMT

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

Re: Database Migration from MySql to MSSQL 2005

groutal — Fri, 28 Aug 2009 12:33:29 GMT

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/

Re: Database Migration from MySql to MSSQL 2005

jean3167 — Mon, 31 Aug 2009 08:03:24 GMT

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.

Re: Database Migration from MySql to MSSQL 2005

dmsoft — Mon, 31 Aug 2009 17:27:37 GMT

Hello,

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