Skip to content

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: - General Migration Guide - High-level migration strategy - Quick Start Guides - Protocol-specific guides

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