WordPress and Microsoft SQL Server

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:

  1. You can migrate your WordPress site from Microsoft SQL Server to MySQL using All-in-One WP Migration.
  2. 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.

Leave A Comment?