convert a phpmyadmin mysql database directly to mssql server or access

Damien W 6 Reputation points
2022-10-24T01:35:12.87+00:00

Hi Microsoft,

Do you have any utilities or wizards to convert a mysql database on at / under a phpmyadmin directly to ms sql server or ms access.

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,117 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Dillon Silzer 54,931 Reputation points
    2022-10-24T01:37:40.39+00:00

    Hi @Damien W

    Please see the following:

    1) Migration guide: MySQL to SQL Server

    Verify that your source environment is supported. Currently, MySQL 5.6 and 5.7 are supported.

    https://learn.microsoft.com/en-us/sql/sql-server/migrate/guides/mysql-to-sql-server?view=sql-server-ver16

    2) Migration from MySQL to MS Access via MySQL ODBC driver (Stack Overflow)

    https://stackoverflow.com/questions/5465661/converting-mysql-to-ms-access


    If this is helpful please accept answer.