Database Migration
35 items tagged with "database-migration"
Best Practices4
Strangler Fig Modernization Pattern
Incrementally replacing legacy systems by routing new functionality to a new service while ‘strangling’ the old.
Continuous Modernization Playbook
Iterative roadmap for refactoring, re-platforming, and replacing legacy systems using automation and AI.
Expand and Contract Database Migration Pattern
A zero-downtime schema change technique that adds new structures, migrates reads and writes in phases, then removes the old structures once nothing depends on them.
API Pagination Best Practices
Techniques for returning large result sets in pages without breaking under concurrent writes: offset, cursor (keyset), and page-token pagination, with stable ordering.
Blueprints10
Oracle to PostgreSQL Migration Blueprint
Migrate an Oracle Database workload to PostgreSQL, converting PL/SQL, data types, and schema while preserving data integrity.
SQL Server to PostgreSQL Migration Blueprint
Migrate Microsoft SQL Server to PostgreSQL, converting T-SQL, data types, and schema to remove licensing cost.
MySQL to Amazon Aurora Migration Blueprint
Migrate self-managed MySQL to Amazon Aurora MySQL-Compatible for managed scaling, HA, and reduced operational toil.
On-Prem Database to Cloud Managed Database Blueprint
Move an on-premises relational database to a cloud managed service (RDS, Cloud SQL, or Azure Database) for elasticity and reduced ops.
Relational to MongoDB Migration Blueprint
Re-model a normalized relational schema into MongoDB document collections for flexible schemas and scale-out reads.
Relational to Apache Cassandra Migration Blueprint
Migrate a relational workload to Apache Cassandra with query-first data modeling for write-heavy, globally distributed scale.
Single Database to Database-per-Service Blueprint
Decompose a shared monolithic database into per-service data stores to enable independent microservice deployment.
Build a Change Data Capture (CDC) Pipeline Blueprint
Stand up a CDC pipeline with Debezium and Kafka to stream database changes in real time to downstream consumers.
Elasticsearch to OpenSearch Migration Blueprint
Migrate an Elasticsearch cluster to OpenSearch to stay on an Apache 2.0-licensed, community-driven search engine.
Self-Managed Elasticsearch to Amazon OpenSearch Service Blueprint
Move a self-managed Elasticsearch cluster to the managed Amazon OpenSearch Service for reduced operational overhead.
Products2
Playbooks4
Oracle to PostgreSQL Migration Program Playbook
Run an enterprise program to migrate Oracle databases to PostgreSQL, covering schema conversion, PL/SQL rewrite, data movement, and cutover.
Zero-Downtime Database Migration Program Playbook
Migrate a production database engine or version with no downtime using dual-write, CDC replication, shadow reads, and staged cutover.
SQL Server to PostgreSQL Migration Program Playbook
Migrate SQL Server databases to PostgreSQL, converting T-SQL, schema, and data with validated cutover to cut licensing costs.
MongoDB to PostgreSQL Migration Program Playbook
Migrate document data from MongoDB to PostgreSQL, modeling collections into relational and JSONB schemas with validated cutover.
Checklists11
Database Migration Checklist
Detailed checklist for safely migrating databases with minimal downtime
Database-Per-Service Decoupling Checklist
Separate a shared database into per-service ownership so microservices can deploy and scale independently without hidden coupling.
Database Migration Cutover Checklist
Step-by-step verification for safely switching production traffic from a source database to a migrated target with minimal risk.
Oracle to PostgreSQL Pre-Flight Checklist
Pre-migration readiness checks for moving an Oracle database to PostgreSQL, covering data types, PL/SQL, and feature gaps.
Zero-Downtime Database Migration Checklist
Checks for migrating a production database with no service interruption using dual-write, CDC, and gradual cutover techniques.
Schema Change Safety Checklist
Safety checks for applying database schema changes to production without locking tables or breaking running applications.
MongoDB to PostgreSQL Migration Checklist
Readiness checks for migrating a document database on MongoDB to a relational PostgreSQL model.
Database Version Upgrade Checklist
Checks for upgrading a database engine to a new major version with minimal risk to data integrity and availability.
SQL Server to PostgreSQL Migration Checklist
Pre-migration readiness checks for moving a Microsoft SQL Server database to PostgreSQL, covering T-SQL, data types, and feature gaps.
SAP S/4HANA Readiness Checklist
Assess data, custom code, and integrations before migrating an SAP ECC landscape to S/4HANA.
Oracle Forms Modernization Assessment Checklist
Assess an Oracle Forms application for modernization to a modern web stack, covering inventory, business logic, and data access.