How to migrate MySQL 8 database to SQL server 2008 R2 Database

Question

Hi all, I want to migrate MYSQL 8.0 database to SQL server 2008 R2. What I tried: I installed SQL server migration assitance(SSMA) for MYSQL and tried to migrate my database. But when I opened SSMA and when I clicked on New Project then on new project window; under migrate to option I did not find option for sql server 2008 R2. All options were having sql server from 2012(versions greater than 2008). Still I clicked on save button then it showed message that sql server version is smaller than SSMA's provided sql server versions. So, how to convert mysql 8 database to sql server 2008R2. Is there any other way to do this? Thank you in advance.Any help would be appreciated.

Amira Bedhiafi · Answer

Microsoft's SQL Server 2008 (and 2008 R2 ) is now out of support . It was officially retired by Microsoft on July 9, 2019. That means the database is no longer receiving any updates or security patches and is no longer guaranteed to be compatible with current and upcoming versions of Windows.

Rijwan Ansari · Answer

Hi dip, You can do this by - First create another environemnt with MS SQL higher version (latest version) and do the migration. You can use developer version which is completely free. link: https://www.sqlshack.com/migrate-mysql-tables-sql-server-using-sql-server-migration-assistant-ssma-ssis/ - After successful migration, you can generate script from the database and restore manually form script to your desire version ( lower version)

dip s · Answer

@salman Beg. Thank you for your reply. I am already taking refernce of these links which you have suggested. The problem is SSMA version which I have does not support migration for SQL server 2008 r2. It supports higher versions of SQL server. Even I searched for SSMA version which supports SQL server 2008 r2 but could not find it.

Salman Beg · Answer

Check this link, https://www.sqlshack.com/migrate-mysql-tables-sql-server-using-sql-server-migration-assistant-ssma-ssis/ https://docs.microsoft.com/en-us/iis/web-hosting/migrate-to-the-microsoft-web-platform/migrate-from-mysql-to-sql-server-2008 https://www.mssqltips.com/sqlservertip/2613/export-data-from-mysql-to-sql-server/