Using the Converter

Covers the full workflow for converting an ElevateDB database to MySQL or MariaDB — from connecting to the remote server through schema conversion, data migration, and SQL console usage.

In This Chapter

• Remote Configuration — connect to the PHP backend and the target MySQL/MariaDB database
• Source Database — open the EDB session and select the database to convert
  • Session Dialog
  • Select Database Dialog
• Target Database — configure server type and default charset/collation
• Charsets and Collations — how EDB collations are mapped to MySQL/MariaDB
  • How Collation Mapping Works
  • Collation Map Editor
    • New Collation Map Entry
• Schema Conversion — generate the SQL script from the EDB schema
  • Data Type Mapping
• Migration Tab — review and run the schema script; launch data migration
  • Pre-Migration Analysis
  • Data Migration Dialog
• SQL Console — run arbitrary SQL on the remote server
  • Export Result Set
  • BLOB / CLOB Viewer

See Also

• How to Use — step-by-step overview of the full workflow
• Installation and Setup