---
title: "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 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 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

7. **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

8. **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

9. **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

10. **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

11. **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](https://www.heliosdb.com/docs/full/reference/protocols/migration_guide/) - High-level migration strategy
- [Quick Start Guides](/docs/full/quick-starts/protocols/) - 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

- [Parent Directory](https://www.heliosdb.com/docs/full/reference/protocols/readme/) - Protocol documentation overview
- [User Guides](/docs/full/guides/user/) - End-user documentation