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?
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. It only takes a minute to sign up.Sign up to join this community
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.