Ora2Pg
Configuration

MySQL Export

Configuration for MySQL and MariaDB migration

Control MySQL export behavior

  • MYSQL_PIPES_AS_CONCAT

    Enable this if double pipe and double ampersand (|| and &&) should not be taken as equivalent to OR and AND. It depends on the variable @sql_mode. Use it only if Ora2Pg fails on auto-detecting this behavior.

  • MYSQL_INTERNAL_EXTRACT_FORMAT

    Enable this directive if you want EXTRACT() replacement to use the internal format returned as an integer, for example DD HH24:MM:SS will be replaced with format; DDHH24MMSS::bigint, this depends on your apps usage.

On this page

Powered by HexaCluster

HexaRocket

Ora2Pg+ for Enterprises

Need enterprise-grade migration? Get zero-downtime & continuous data replication.

Explore HexaRocket