All Modules

SQL Migrate

Database-First Migrations

Finally, migrations that work the right way. Your database schema is the source of truth. SQL Migrate generates Dapper models, TypeScript types, and rollback scripts automatically.

Why Database-First?

Traditional Code-First

  • ORM models define schema (abstraction leak)
  • No stored procedure support
  • Manual Dapper model maintenance
  • DACPAC is all-or-nothing
  • Flyway can't handle complex objects

SQL Migrate Database-First

  • Schema is the source of truth
  • Full SP, view, function support
  • Auto-generated Dapper models
  • Incremental versioned migrations
  • Dependency-aware deployment order

Automatic Code Generation

From one schema, generate code for multiple languages and frameworks.

Dapper Models (C#)

// Auto-generated from dbo.Customers
public class Customer
{
    public int CustomerId { get; set; }
    public string Email { get; set; }
    public string Name { get; set; }
    public string? LoyaltyTier { get; set; }
}

TypeScript Types

// Auto-generated from dbo.Customers
export interface Customer {
  customerId: number;
  email: string;
  name: string;
  loyaltyTier: string | null;
}

Simple Workflow

1

Change Database

Use SSMS, Azure Data Studio, or any SQL tool

2

Detect Changes

sql2ai migrate diff

3

Generate Code

Migration + Dapper + TypeScript

4

Commit & Deploy

CI/CD handles the rest

Ready for Database-First Migrations?

Stop fighting your ORM. Let SQL Migrate generate code from your database.

No credit card required • Free for individual developers