WordPress and Microsoft SQL Server

WordPress does not officially support Microsoft SQL Server. All-in-One WP Migration does not support migration between MySQL and Microsoft SQL Server

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

If you are using legacy environment (and an older version of wordpress), then the minimum requirements are:

  • PHP 5.2.4+
  • MySQL 5.0+

There are 3rd party projects that have a custom database layer in order to support Microsoft SQL Server, such as Project Nami.

Issues arise when trying to migrate from MySQL based WordPress to Microsoft SQL Server based WordPress, because each database server has different specifics in the SQL syntax and they are not fully compatible. All-in-One WP Migration does not support migration between MySQL and Microsoft SQL Server, but we can suggest a couple of workarounds to this problem:

  1. You can switch your WordPress from Microsoft SQL Server to MySQL and migrate your site with All-in-One WP Migration
  2. You can switch your WordPress from Microsoft SQL Server to MySQL temporarily to complete the migration, and then convert your MySQL database to a Microsoft SQL Server database with  a 3rd party tool or by converting it manually.

Leave A Comment?