MySQL PostgreSQL Migration Issues
Every rule the analyzer checks, grouped by category. 12 have a dedicated deep-dive guide; the rest are safe/mechanical enough that the in-tool explanation is the whole story.
Identity & sequences
- MEDIUM AUTO_INCREMENT column
AUTO_INCREMENTMySQL AUTO_INCREMENT → PostgreSQL Migration · PostgreSQL Sequence Reset After AUTO_INCREMENT Migration
Types
- BLOCKER UNSIGNED integer column
UNSIGNED - MEDIUM ENUM column
ENUM - HIGH SET column
SET_TYPENo dedicated guide yet — detected and explained directly in the analyzer report.
Table options
- INFO ENGINE table option
ENGINE_OPTIONNo dedicated guide yet — detected and explained directly in the analyzer report.
- LOW CHARACTER SET / CHARSET option
CHARACTER_SET_OPTION - LOW COLLATE option
COLLATE_OPTIONNo dedicated guide yet — detected and explained directly in the analyzer report.
Indexes
- HIGH FULLTEXT index
FULLTEXT_INDEX - HIGH SPATIAL index
SPATIAL_INDEXNo dedicated guide yet — detected and explained directly in the analyzer report.
- MEDIUM Prefix-length index (col(N))
PREFIX_INDEXNo dedicated guide yet — detected and explained directly in the analyzer report.
Defaults & triggers
- HIGH ON UPDATE CURRENT_TIMESTAMP
ON_UPDATE_CURRENT_TIMESTAMP - BLOCKER Zero date literal ('0000-00-00')
ZERO_DATE
Identifiers
- LOW Backtick-quoted identifiers
BACKTICK_IDENTIFIERSNo dedicated guide yet — detected and explained directly in the analyzer report.
Functions
- LOW IFNULL() function call
IFNULLNo dedicated guide yet — detected and explained directly in the analyzer report.
- MEDIUM GROUP_CONCAT() function call
GROUP_CONCAT - MEDIUM DATE_FORMAT() function call
DATE_FORMAT - LOW LIMIT offset, count shorthand
LIMIT_OFFSET_COUNTNo dedicated guide yet — detected and explained directly in the analyzer report.
- HIGH INSERT IGNORE
INSERT_IGNORE - HIGH ON DUPLICATE KEY UPDATE
ON_DUPLICATE_KEY_UPDATE
Scheduling
- BLOCKER MySQL EVENT (scheduler)
MYSQL_EVENTNo dedicated guide yet — detected and explained directly in the analyzer report.
MySQL & MariaDB Version Differences
View full matrixCompare any two versions
All 45 released MySQL and MariaDB version lines are listed here — pick any two. Source: endoflife.date (aggregating official MySQL/Oracle and MariaDB Foundation EOL announcements), checked 2026-07-31.
Ready to check your own schema?
Run the analyzer against your own database definition to get a customized migration report.
Analyze a schema free