Files
SQLWorkbench/docs/PHASE65-SCHEMA-SYNCHRONISATION.md

927 B

Phase 65 — Reviewed additive schema migration

From Compare Schema Structures…, select Review Additive Migration…. Choose missing columns, review the SQL, copy it, or open it in a new SQL editor tab.

Safety boundary

The generator only creates ALTER TABLE ... ADD COLUMN for columns present in the source but absent in an existing target table. It deliberately does not generate DROP, MODIFY, table creation, view creation, key/index changes, or automatically execute any DDL. Full table and view definitions and index dependencies are not available in the existing introspection snapshot. Auto-increment columns are skipped. No statement is applied without an explicit subsequent user action in the SQL editor.

Review constraints, defaults, data compatibility, and backups before execution. MySQL DDL generally causes implicit commits. Re-introspect both databases before preparing a migration.