Changelog
All notable changes to this project will be documented in this file.
The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.
[Unreleased]
[1.7.0] - 2026-11-04
Added
- Concurrent traversal of named database sources using the existing migration service, with configurable parallelism, independent results, cleanup and cancellation.
- Shared SSH/proxy configuration defaults for named data sources, with optional per-source overrides and independently owned runtime connections.
- Initialization flags for zero-based shards with configurable counts, SSH authentication, SOCKS5/HTTP proxies and explicit YAML/JSON output, without resolving or storing secret values.
Changed
- Generate commented YAML configurations by default. Discover
.yml,.yaml, then legacy.jsonconfigurations while preserving single-source JSON support.
Fixed
- Report the installed Go module version in
versionandcapabilitieswhen the CLI is installed withgo install ...@version; retain explicit release build versions and thedevfallback for local development builds. - Add the documentation website favicon with the correct GitHub Pages base path across all language pages.
[1.6.0] - 2026-11-04
Added
- Native SSH tunnels for PostgreSQL/MySQL/MariaDB/MSSQL/Oracle/ClickHouse/TiDB/Redshift with optional SOCKS5 or HTTP CONNECT proxies, strict host verification, environment or hidden terminal secrets, noninteractive CLI mode, and an owned Go connection API.
- Ask-style first-use SSH host trust with explicit fingerprint confirmation, saved known_hosts records and unchanged rejection of changed or revoked host keys.
- A topic-based English and Chinese documentation website with runnable quick starts, CLI and Go API references, and published release notes.
Changed
- Remove the optional
fullbuild mode and SQL-only runtime stubs; SQL, JS, TS and MJS migrations share one CLI. - Publish one binary per platform without
_fullassets, and run one CI build configuration with both SQL and script coverage. - Remove the
builddiscriminator from capabilities output; formats and script dialect metadata describe the supported capabilities.
Fixed
- Keep the SSH handshake timeout paused until an approved host key is saved and verified, so local file-lock waits and filesystem syncs do not abort host trust.
[1.5.0] - 2026-11-03
Added
- Runnable SQLite examples for shared script modules, package.json/npm imports and embedded Go migrations, with bilingual instructions and a CI smoke check.
- Static JS/TS/MJS imports and re-exports, plus installed npm packages bundled for Goja. Embedded and in-memory sources support relative modules and explicit disk dependency directories; no Node runtime or package installation is added.
- Per-script
export const config = { transaction: false }for native SQL/manual transactions on a dedicated connection, with explicit partial-state diagnostics. - Experimental JS/TS/MJS migration execution for TiDB, Redshift, Oracle, ClickHouse and MSSQL.
- A shared case-insensitive alias catalog for SQL and scripts, including PostgreSQL pg/pgsql/postgresql/pgx and MSSQL sqlserver/azuresql; scripts expose canonical names.
- Per-dialect verification status, aliases, transaction modes and limitations in capabilities, plus one warning per selected experimental script plan.
- ClickHouse scalar value conversion and explicit partial-state errors for nontransactional execution/history failures; driver-reported affected-row counts remain strings.
- ClickHouse/TiDB/MSSQL container CI and optional SQL/full Oracle/Redshift/MSSQL integration.
Fixed
- Restore Linux/Windows x86 SQL and full builds by pinning the upstream Oracle driver fix for 32-bit INTERVAL integer overflow.
- Ignore ordinary synchronous script return values and allow caught SQL failures to recover with subsequent calls without classifying vendor error codes. Promise, actual execution cancellation, overall timeout, validation and resource-limit failures remain fatal; commit/history errors still fail the migration.
- Reuse successful nontransactional script connections through the pool; discard only failed/panicked steps, preserving cleanup of unfinished manual transactions.
- Forward script SQL unchanged to database drivers; remove keyword/single-statement restrictions and the handwritten MSSQL validator while retaining runtime limits.
- Upgrade the Oracle driver to go-ora v3 for modern authentication; disable its fast login cache by default while preserving explicit options. Correct Oracle history DDL, native status binding and missing result metadata handling.
- Serialize external SQL/full CI against each dedicated database to avoid fixture races.
Compatibility
- Script checksums continue to cover entry source only. Editing imported helpers or packages does not trigger history mismatches or replay applied migrations; authors retain historical dependency behavior and pin installed package versions.
- Default builds remain SQL-only. Existing script_dialects JSON output is preserved; script_dialect_capabilities adds detailed status. New dialects remain experimental.
- Oracle DDL implicitly commits. ClickHouse scripts cannot automatically roll back; inspect data and history before retrying failures. Generated declarations include all executable dialects with string affected-row counts.
[1.4.0] - 2026-11-02
Added
- Accept
.mjsas a JavaScript migration alias in full builds; SQL-only builds detect and reject it before migration writes. Supportnew version --format mjs. - Optional
fullbuilds support standalone synchronous JS/TS migrations alongside SQL, with framework-owned transactions, exact value conversion, source checksums, execution deadlines and query result limits. capabilitiesreports compiled formats without configuration or a connection.new version --format sql|js|ts|mjscreates migration templates; script timeout and result limits can be configured through JSON or the Go facade.- Generated JS/MJS templates include JSDoc database types; TS templates provide equivalent method, parameter and result declarations for editor assistance.
- SQL/full CI matrices and real-driver script integration for PostgreSQL, MySQL, MariaDB and SQLite; full release binaries and editor API declarations.
Fixed
- Migration callbacks that panic now roll back instead of entering deferred commit.
- Execution validates complete selected plans before changing data, including irreversible rollback ranges and unsupported script capabilities.
Compatibility
- Default binaries and existing release filenames remain SQL-only. Existing SQL hashes, migration history and version command output remain unchanged.
- Known JS/TS/MJS migration files are discovered by both builds; SQL-only execution refuses them instead of silently skipping required versions.
[1.3.1] - 2026-04-22
Fixed
- Configuration JSON parse errors now include the config file path, line, and column. Extra non-JSON content after the config object is reported with a clear remediation hint instead of only the raw Go parser message.
Added
- Regression coverage for
migrate status -w <dir>when<dir>/migration_config.jsoncontains trailing non-JSON content. - Configuration parsing coverage for DSNs that use environment defaults and passwords containing special characters such as
$,,, and>.
[1.3.0] - 2026-04-20
Added
- Public root-package facade (
github.com/exc-works/migrate) so other Go services can embed migration execution in-process alongside the existingcmd/migrateCLI. ExportsService,Config,Statusconstants, dialect constructors (migrate.NewPostgresDialect(),NewMySQLDialect(), etc.), migration sources, and logger types.internal/*remains private. FSSourceloads migrations from anyfs.FS— works with//go:embed,os.DirFS, orfstest.MapFS(test-friendly).- User guides translated into 10 additional languages: ar, de, es, fr, hi, ja, ko, pt-BR, ru, zh-Hant. Each guide gains a new section 12 documenting library usage.
[1.2.1] - 2026-04-17
Changed
- CLI error messages and help output refined for both human users and agent-driven workflows.
[1.2.0] - 2026-04-14
Added
- Top-level
migrate --versioncommand.
[1.1.1] - 2026-04-14
Fixed
- Track
cmd/migratesources in git; narrowed.gitignoreso the binary build artifact no longer excludes source files.
[1.1.0] - 2026-04-14
Changed
- Renamed binary and module from
sql-migratetomigrate. - Release workflow now targets Linux arm64 / x64 / x86.
- GitHub Actions bumped to Node 24–compatible versions.
Fixed
- Oracle integration secret gating in CI.
[1.0.0] - 2026-04-14
Initial tagged release.
Added
- Dialect support: PostgreSQL, MySQL, MariaDB, MSSQL, Oracle, SQLite, ClickHouse, TiDB, Redshift.
- Bilingual (zh-CN, en) user guides.
- Tag-based multi-platform release workflow.