Migrating MySQL to SQL Server 2012 using SSMA 5.2 RRS feed

  • Question

  • Hi all,

    I am new to SQL Server, and am using it in a new job that I started a couple of weeks ago.  They are now migrating from 2008 R2 to 2012 and one of the steps in the project is migrate over an existing MySQL database at the same time.

    I heard about the SSMA and thought this would make my life a lot easier, but I've fallen at the first hurdle.  MSSQL is on SERVER1 and MySQL is on SERVER2, when I try to install the SSMA it says that "Setup is unable to find MySQL ODBC driver", does MSSQL and MySQL both have to be on the same server?  Or do I only have to install an ODBC driver / connection?

    Hope you can help.



    Tuesday, July 3, 2012 3:14 PM


All replies