Skip to content
HeliosDB Full

Database Migration Guides

Database Migration Guides

This directory contains comprehensive migration guides for migrating from various database systems to HeliosDB.

Migration Guides by Source Database

Relational Databases

  1. MIGRATION_FROM_ORACLE_TO_HELIOSDB.md - Comprehensive Oracle to HeliosDB migration (1000+ lines) with PL/SQL conversion, DBMS package mapping, Flashback to Time Travel, Data Pump import, and application connectivity
  2. MIGRATION_FROM_DB2_TO_HELIOSDB.md - Comprehensive IBM DB2 to HeliosDB migration (800+ lines) with DRDA wire protocol compatibility, SQL PL procedure migration, EXPORT/IMPORT to COPY conversion, data type mapping, and multi-language application connectivity (Java, Python, .NET, Node.js)
  3. MIGRATION_FROM_POSTGRESQL_TO_HELIOSDB.md - Migrate from PostgreSQL to HeliosDB (Recommended - 100% wire protocol compatible)
  4. MIGRATION_FROM_MSSQL_TO_HELIOSDB.md - Migrate from Microsoft SQL Server to HeliosDB
  5. MIGRATION_FROM_MYSQL_TO_HELIOSDB.md - Migrate from MySQL to HeliosDB
  6. MIGRATION_FROM_SQLITE_TO_HELIOSDB.md - Migrate from SQLite to HeliosDB

Document Databases

  1. MIGRATION_FROM_MONGODB_TO_HELIOSDB.md - Comprehensive MongoDB migration guide with query translation, aggregation pipeline mapping, change streams to CDC conversion, and geospatial feature mapping

Wide-Column Databases

  1. MIGRATION_FROM_CASSANDRA_TO_HELIOSDB.md - Comprehensive Apache Cassandra migration guide with CQL wire protocol compatibility, keyspace/table mapping, TTL support, collections, UDTs, and LWT migration

Analytical / OLAP Databases

  1. MIGRATION_FROM_CLICKHOUSE_TO_HELIOSDB.md - Comprehensive ClickHouse migration guide (92% compatibility) with MergeTree family engine mapping, native/HTTP protocol support, materialized view migration, aggregation functions, data type mapping, and performance optimization

Cloud Data Warehouses

  1. MIGRATION_FROM_SNOWFLAKE_TO_HELIOSDB.md - Comprehensive Snowflake migration guide (1000+ lines, 90%+ compatibility) with Time Travel migration (AT/BEFORE syntax), VARIANT semi-structured data, FLATTEN function, virtual warehouse mapping, COPY INTO data loading, stage/storage integration, and application connectivity (Python snowflake-connector, JavaScript snowflake-sdk)

In-Memory / Key-Value Databases

  1. MIGRATION_FROM_REDIS_TO_HELIOSDB.md - Comprehensive Redis migration guide covering persistence unification, data structure mapping (Strings, Hashes, Lists, Sets, Sorted Sets to SQL equivalents), command mapping, Pub/Sub to real-time events, Lua scripting alternatives, caching layer considerations, and performance optimization

Standard Naming Convention

All migration guides follow the naming pattern: MIGRATION_FROM_[SOURCE_DATABASE]_TO_HELIOSDB.md

This ensures consistency and makes it easy to find migration documentation for any supported source database.

General Migration Process

Most migrations follow these general steps:

  1. Schema Conversion - Convert database schema to HeliosDB SQL
  2. Data Migration - Migrate data using migration tools or ETL processes
  3. Application Update - Update application connection strings and drivers
  4. Testing - Verify data integrity and application functionality
  5. Cutover - Switch production workloads to HeliosDB

Common Challenges

  • Dialect differences between SQL systems
  • Data type mappings
  • Trigger and procedure conversions
  • Performance optimization on new system
  • Downtime minimization

Available Tools

HeliosDB provides several tools for migration:

  • Migration Toolkit - Automated schema and data migration
  • Data Validation Tools - Verify data integrity post-migration
  • Performance Monitoring - Monitor migration performance

Support

For migration assistance and best practices, refer to:

Planned Migrations

Additional migration guides are planned for:

  • BigQuery (MIGRATION_FROM_BIGQUERY_TO_HELIOSDB.md)
  • DynamoDB (MIGRATION_FROM_DYNAMODB_TO_HELIOSDB.md)

Check back or submit a feature request for specific migration guides.

See Also