Database Migrations. Professional Grade.
Deploy versioned SQL migrations to multiple databases simultaneously. SQL Server, PostgreSQL, MariaDB & MySQL — with enterprise-level safety and control.
Trusted across database platforms
Everything you need for safe migrations
Built for teams that take database integrity seriously. Every feature designed to prevent disasters, not just manage them.
Multi-Target Deployment
Deploy one migration run to multiple targets simultaneously or successively. Sharded DBs, read replicas — one command.
Separate Repository Database
Track all migrations centralized, separate from targets. SQL Server + PostgreSQL + MariaDB in one repository.
Block-Level Progress Tracking
Individual SQL blocks tracked. Know exactly where a migration stopped, not just which file.
Transactional Safety
4 error handling modes: Terminate, Rollback, RollbackErrorOnly, RollbackRelease. Your data stays safe.
Hash Validation
SHA-256 integrity checks with 3 scopes: File, SqlBlocks, or Disabled. Detect unauthorized changes to executed migrations.
Rollback Support
Paired rollback files enable safe downgrades to any previous release. Always have an exit strategy.
Concurrency Protection
Check-and-insert locking pattern prevents concurrent migration runs. Safe for CI/CD pipelines and multi-instance deployments.
3 Run Modes
Migrate applies changes, Simulate shows what would happen, Validate checks integrity — without touching data.
Hierarchical Configuration
6-level raysettings.txt inheritance + 4-file appsettings.json hierarchy. One setup, every environment.
Out-of-Order Migrations
Run migrations out of sequence with --allow-out-of-order (-ooo). Ideal for parallel development across teams and branches.
Release-Based Execution
Migrations execute in release order first, then file order within each release. Predictable deployment across environments.
RunAlways Migrations
Mark files with RunAlways = true to re-execute on every run. Perfect for stored procedures, views, and seed data.
How it works
Four simple steps from writing migrations to verified deployments.
Write
Write SQL migrations with TOML metadata headers
.sql files with metadataConfigure
Define products, target groups, and environments in appsettings.json + raysettings.txt
appsettings.jsonRun
Execute with CLI — choose your run mode for each deployment
Migrate | Simulate | ValidateTrack
Block-level progress, checksums, and history archiving in a separate repository DB
SHA-256 verifiedPowerful CLI, simple commands
Seven commands cover your entire migration lifecycle — from initial deployment to production rollbacks and orphaned run recovery.
Clean, layered architecture
Six cleanly separated layers following SOLID principles. Each layer has a clear responsibility and minimal coupling.
Console Layer
CLI entry point powered by System.CommandLine
Service Layer
Business logic orchestration and migration pipeline
Core Layer
Domain models, MigrationContext, and options
Infrastructure Layer
Database logging, hierarchical config, and transient error retry
Database Layer
19 SQL templates per DB type, advisory locking, and DAL implementations
Shared Layer
Common types, enums, and exception definitions
Elegant migration file format
TOML metadata headers embedded in SQL files. Your migrations stay valid SQL while carrying rich configuration.
TOML Metadata Block
Wrapped in a SQL comment block. Controls execution behavior, environment targeting, and transaction handling.
Environment Filtering
Target specific environments or use wildcards. Skip dev-only seed data in production.
Standard SQL
The migration body is plain SQL. No proprietary syntax, no XML, no learning curve.
6-Level Settings Inheritance
raysettings.txt cascades from global → product → target group → target → environment → release. Override only what you need.
Environment-Specific Files
Name files like 001_seed.Production.sql to run them only in specific environments. No config needed — just a naming convention.
Let AI write your migrations
Paste your schema, describe your change, get production-ready migration files — with correct TOML metadata, rollback scripts, and database-specific SQL.
-- Your schema
CREATE TABLE Users (
Id INT IDENTITY(1,1) PRIMARY KEY,
Username NVARCHAR(100) NOT NULL,
Email NVARCHAR(255) NOT NULL
);↓ AI generates migration + rollback
-- Generated by RAYCOON AI for SQL Server
-- Input: "Add audit columns to the Users table"
/*
[RayMigrator]
Description = "Add audit columns to Users table"
Environments = ["*"]
Targets = ["*"]
UseTransaction = true
RunAlways = false
RequireRollbackFile = true
*/
ALTER TABLE Users
ADD CreatedAt DATETIME2 NOT NULL
DEFAULT GETUTCDATE(),
UpdatedAt DATETIME2 NULL,
CreatedBy NVARCHAR(100) NOT NULL
DEFAULT SYSTEM_USER;
GO
CREATE NONCLUSTERED INDEX IX_Users_CreatedAt
ON Users(CreatedAt DESC);The AI Playground understands your existing schema. Paste your CREATE TABLE statements, describe the change you need, and get production-ready migration files with proper TOML metadata, rollback scripts, and database-specific SQL idioms.
Coming soon as part of RayMigrator Pro
How RayMigrator compares
See how RayMigrator stacks up against popular migration tools.
| Feature | RayMigrator | Flyway | Liquibase | EF Migrations |
|---|---|---|---|---|
| Separate Repository DB | ||||
| Block-Level Progress Tracking | ||||
| 3 Run Modes (Migrate/Simulate/Validate) | ||||
| Concurrency Protection | ||||
| 6-Level Settings Inheritance | ||||
| Database Logging | ||||
| Orphaned Run Recovery | ||||
| Env Variable Substitution in SQL | ||||
| Multi-Target Deployment | ||||
| Multi-Database Support | ||||
| Transactional DDL | ||||
| SHA-256 Hash Validation | ||||
| Paired Rollback Files | ||||
| Config Hierarchy | ||||
| CLI Tool | ||||
| Pure SQL Files | ||||
| TOML Metadata | ||||
| Environment Targeting | ||||
| Out-of-Order Migrations | ||||
| RunAlways Migrations | ||||
| Baseline Command | ||||
| Environment-Specific SQL |
What's next
RayMigrator is actively developed. Here's what we're working on.
Oracle Database Support
Full Oracle support with PL/SQL statement handling.
SQLite Support
Lightweight migrations for embedded and mobile applications.
User Manual
Comprehensive documentation covering all features and configuration options.
Get started in 3 steps
From zero to first migration in under 5 minutes.