SchemaForge.Providers.SqlServer 2.0.1

SchemaForge

A high-performance, cross-database migration tool for .NET that migrates schemas and data between different database systems. Designed for enterprise-scale moves, SchemaForge handles complex views, cross-schema foreign keys, and massive datasets with ease.

Supported Databases

• SQL Server (source and target)
• PostgreSQL (source and target)
• MySQL (source and target)
• Oracle (source and target)

Features

• Robust Schema Migration - Automatic creation of tables, primary keys, and complex foreign key relationships across all 4 platforms.
• Enterprise-Grade Constraints - Implements "Future Enforcement, Past Forgiveness" model using ENABLE NOVALIDATE (Oracle), NOT VALID (Postgres), and WITH NOCHECK (SQL Server) to ensure migrations complete even with legacy data orphans.
• Automated Infrastructure - Automatically creates target databases, schemas, and Oracle users/permissions on-the-fly.
• High-Performance Data Transfer - Parallel table migration with batched bulk writes, read-ahead pipelines, and sql_log_bin=0 (MySQL) for maximum speed and disk efficiency.
• Intelligent View Migration - Sophisticated SQL dialect conversion for view definitions, handling complex functions like DECODE, BITAND, SYSDATETIME, and varied quoting styles.
• Verified with WideWorldImporters - Stress-tested and verified using the full, multi-schema production dataset from Microsoft.
• Plugin-Based Architecture - Fully extensible provider model built on .NET 9 and standard interfaces.
• Dry Run Mode - Generate and preview complete migration SQL scripts without executing against the target.

Quick Start

Install as a .NET global tool

# Install from NuGet
dotnet tool install --global SchemaForge.Cli

# Run a migration
schemaforge --from postgres --to oracle \
  --source-conn "Host=127.0.0.1;Database=prod;Username=pg;Password=..." \
  --target-conn "User Id=system;Password=...;Data Source=127.0.0.1:1521/FREEPDB1" \
  --schema SALES --verbose

Use as a library in your .NET app

dotnet add package SchemaForge
dotnet add package SchemaForge.Providers.SqlServer
dotnet add package SchemaForge.Providers.Postgres

using SchemaForge.Builder;

await DbMigrate
    .FromSqlServer(srcConn)
    .ToPostgres(targetConn, "public")
    .MigrateAll()
    .WithMaxParallelTables(4)
    .ExecuteAsync();

CLI Usage

Data Type Mapping

Changelog

v2.0.1 — Enterprise Resilience Update

• Major Release — Full 12-path verification matrix complete with WWI dataset.
• Robust FKs — Implemented ENABLE NOVALIDATE (Oracle), NOT VALID (Postgres), and WITH NOCHECK (SQL Server).
• MySQL Driver Upgrade — Switched to MySqlConnector for superior Docker/SSL stability.
• Infrastructure Automation — Added EnsureDatabaseExistsAsync for SQL Server and MySQL.
• Dialect Expansion — Added support for BITAND, DECODE, and FROM_TZ translations.
• API Enhancement — New WithMaxParallelTables(n) and WithSourceSchemaFilter fluent methods.
• Performance — Implemented sql_log_bin=0 for MySQL to prevent "Disk Full" errors during large moves.
• Bug Fixes — Fixed 15+ critical bugs in view routing, regex backreferences, and identifier quoting.

v1.0.51

• Fixed SQL Server to SQL Server migration issues and cross-schema FK references.