Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm just getting into MySQL, so forgive me if this is a basic question. For my application I need to migrate my database from SQL Server 2008 R2 to MySQL.

Is there any mechanism or technique or suggestion or tips or magic tricks for migration?

share|improve this question
Hey shamim, I removed the last two lines from your question as I didn't see they added any information to it. Feel free to edit if I misunderstood. – Nick Chammas Jan 18 '12 at 6:31
up vote 2 down vote accepted

You can use tools which are very efficient in migrating the data from one type of the database to other.

There are many types of tools some of them are freely available.I have used Talend which is very efficient in doing this.

It is also freely available.

share|improve this answer
@Shamim : you can download Talend Open Studio and start working if have any questions let me know. – Abdul Manaf Jan 18 '12 at 6:37
thanks for reply. – shamim Jan 18 '12 at 9:00

Moving the data is the easy part. The T-SQL code all needs to be checked to ensure that you aren't using any SQL Server specific features like TOP, CTEs, SQL CLR, etc and that'll all need to be converted. Even if there's a tool to convert it, you'll need to test everything to make sure that everything is still working the way that you want it to be working.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.