MySQL

ODBC Connection Tune

• ODBC Driver Installation
• ODBC Driver Configuration

Settings

• Source User Privileges

Settings

• Target User Privileges
• Bin Directory and Utilities to Perform Import

Troubleshooting

• ERROR 1067 (42000) Invalid Default Value for / ERROR 1292 (22007) Incorrect Datetime Value: - Zero Date is Not Accepted by Timestamp
• ERROR 1419 (HY000): You Do Not Have the SUPER Privilege and Binary Logging is Enabled
• ERROR 1071 (42000): Specified Key was Too Long; Max Key Length is 767 Bytes
• ERROR 2003 (HY000): Can't Connect to MySQL Server on ‘IP Address’ (Port)
• ERROR 1598 (HY000): Binary Logging Not Possible. Message: Transaction Level READ-COMMITTED in InnoDB is Not Safe for Binlog Mode STATEMENT
• ERROR 1148 (42000): The Used Command is Not Allowed with this MySQL Version
• ERROR 3948 (42000) at Line 1: Loading Local Data is Disabled; This Must be Enabled on Both the Client and Server Sides
• DECIMAL Value conversion
• Returning Single Value from Stored Procedure
• Outer Apply and Cross Apply Conversion from Microsoft SQL Server to MySQL and PostgreSQL
• Referring to a TEMPORARY Table More Than Once in the Same Query in MySQL
• Sequences Conversion from Microsoft SQL Server to MySQL
• TRUNC (date) Function Conversion from Oracle to MySQL

Tool Specifics

• Advanced Options