SQompare v1.2.1

SQompare Release v1.2.1

SQompare v1.2.0

SQompare Release v1.2.0

SQompare v1.1.0

New Features & Enhancements

Collation Support

• Table-level collation parsing - Extracts COLLATE, CHARSET, and ENGINE from CREATE TABLE statements
• Column-level collation parsing - Captures individual column CHARACTER SET and COLLATE clauses
• Smart collation application - Only applies collation to text-based data types (VARCHAR, CHAR, TEXT, etc.)
• Collation priority system - Column-level collation takes precedence over table-level collation

ALTER COLUMN Functionality

• Column difference detection - Compares data type, nullable, default values, charset, and collation
• MODIFY COLUMN queries - Generates ALTER TABLE ... MODIFY COLUMN statements for different columns
• Comprehensive column comparison - Shows side-by-side differences in a modal dialog

Enhanced UI & Visual Feedback

• Dynamic summary icons - Green checkmarks (✅) when 0 missing tables/columns, warning icons otherwise
• Extended table structure view - Shows table properties (Engine, Charset, Collation) and column-level collation
• Enhanced missing columns table - Displays both missing and different columns with action buttons
• Column differences modal - Detailed comparison view showing property differences

Improved Query Generation

• CREATE TABLE with full options - Includes ENGINE, CHARSET, and COLLATE in generated statements
• ALTER TABLE ADD COLUMN - Preserves collation from source tables
• ALTER TABLE MODIFY COLUMN - Updates existing columns with proper collation handling
• Conditional collation output - Respects user toggle for collation inclusion

SQompare v1.0.0

SQompare Windows Release v1.0.0

Download Options:

• SQompare-1.0.0.AppImage - Linux
• SQompare-1.0.0.exe - Windows