RoundhousE
A Professional Database Migration Utility for .NET.
Overview
RoundhousE is an automated database deployment system for .NET. It focuses on running SQL scripts in a specific order based on their location in a directory structure (e.g., up, runFirstAfterUp, functions, views, sprocs, indexes). This allows for both versioned migrations and re-runnable scripts for objects like views and stored procedures.
✨ Key Features
- Convention-based folder structure
- Runs versioned 'up' scripts once
- Re-runs scripts for programmable objects (views, sprocs) every time
- Environment-aware deployments
- Supports SQL Server, Oracle, PostgreSQL, MySQL and more
🎯 Key Differentiators
- Distinction between one-time 'up' scripts and re-runnable scripts for views/sprocs
- Mature and stable tool in the .NET community
- Environment-specific script execution
Unique Value: Provides a powerful, convention-based system for managing both incremental schema changes and the state of programmable database objects.
🎯 Use Cases (2)
✅ Best For
- Deploying changes to a SQL Server database that heavily uses stored procedures and views.
💡 Check With Vendor
Verify these considerations match your specific requirements:
- Projects not using .NET or teams that prefer a code-first migration approach.
🏆 Alternatives
Its built-in handling of re-runnable scripts for views and stored procedures is a key differentiator from tools like DbUp or Evolve, which typically treat all scripts as run-once migrations.
💻 Platforms
✅ Offline Mode Available
🔌 Integrations
💰 Pricing
Free tier: RoundhousE is free and open-source.
🔄 Similar Tools in Schema Migration
Flyway
An open-source database migration tool that favors simplicity and convention over configuration....
Liquibase
An open-source tool for tracking, managing, and applying database schema changes....
Bytebase
A web-based collaboration workspace for DBAs and Developers to manage database schema changes....
Atlas
An open-source tool that brings infrastructure-as-code principles to database management....
Skeema
A declarative, SQL-first schema management tool specifically for the MySQL ecosystem....
DBmaestro
A DevOps platform for databases that automates CI/CD, provides source control, and ensures complianc...