WordPress Migrate SQL

WordPress Migrate SQL lets you build migrations from a WordPress site's MySQL/MariaDB database straight into Drupal. It's recommended for complex WordPress sites and for people who prefer a pure SQL source over WXR exports.

It also offers a ready-to-use migration for common WordPress content and a page to import or roll them back, with not need to write code.

Full setup and usage instructions are in the module's README.md.

Features

• Migrate source plugins for WordPress Users, Terms, Posts (with tags, categories and featured image) and Attachments.
• UI form to configure the WordPress database connection (host, user, password, prefix) and the files base URL, with a built-in "Test connection" button. No settings.local.php tweaks required.
• Process plugins:
  • wordpress_migrate_sql_file_import: downloads remote attachments and saves them as local File entities.
  • wordpress_migrate_sql_unique_username: avoids duplicate-username collisions during user migration.
• Zero-code setup via the bundled WordPress Migrate SQL - Basic submodule: ready-to-run migrations plus an Import/Rollback page. On enable, it installs the Categories vocabulary, a field_categories entity-reference field on the Article content type, and wires the posts migration to populate it from WordPress category terms. See modules/basic/README.md for step-by-step instructions.
• Drush scaffolder (drush generate wordpress-migration) that creates a custom module with the four default migrations — plus optional config for the categories vocabulary and field — so you can tailor them to your content model. See the Scaffolding section of README.md for details.

Recommended modules/libraries

• Migrate Tools (required by the Basic submodule; used for batched imports).
• Migrate Plus

Additional documentation

• Generating WordPress content: if you need sample WordPress content to test your migration, this guide explains how to generate it.

Similar projects

• WordPress Migrate: provides a full content migration from WordPress to Drupal based on the WordPress WXR export format.
• Wordpress to Drupal Migrate: Pretty similar than this module. It already support pages, comments and common shortcodes.

This module differentiates from others to provide a solution that is able to be installed without needing to code, but also allow developers to make customized migrations. Customized migrations allow cover use cases that are not covered by the basic migration.

In future plans the module will also provide reports to quick glance which content is migrated and which content is still missing.