WordPress does not officially support Microsoft SQL Server. All-in-One WP Migration does not support MySQL to Microsoft SQL Server migration.
WordPress recommends that the configuration for your host is:
- PHP version 7 or greater
- MySQL version 5.6 or greater OR MariaDB version 10.0 or greater
- HTTPS support
The following are the minimum requirements if you are using a legacy environment (and an older version of WordPress):
- PHP 5.2.4+
- MySQL 5.0+
Third-party projects, such as Project Nami, have a custom database layer to support Microsoft SQL Server.
When attempting to migrate from MySQL-based WordPress to Microsoft SQL Server-based WordPress, problems arise because each database server has unique SQL syntax that is not fully compatible. All-in-One WP Migration does not support migration between MySQL and Microsoft SQL Server, but we can recommend a few workarounds:
- You can migrate your WordPress site from Microsoft SQL Server to MySQL using All-in-One WP Migration.
- You can switch WordPress from Microsoft SQL Server to MySQL temporarily to complete the migration, and then use a third-party tool or manually convert your MySQL database to a Microsoft SQL Server database.