Command-line tool for database comparison, update script generation, and schema export to JSON.
The executable is typically named BaseDiffConsole (for example BaseDiffConsole.exe on Windows). It is designed for automation, CI/CD pipelines, and advanced database management tasks.
BaseDiffConsole <command> [arguments...]
Lightweight comparison — mainly tables and columns (create / drop / alter).
Configuration is either a BaseDiff project file (.bdfJson) or explicit connection parameters.
| Alias | Type | Description |
|---|---|---|
s | silent | Flag | Minimal console output FLAG |
p | project | String | Path to the project file (.bdfJson) |
sdt | sourceDatabaseType | Enum | MSSQL, PostgreSQL, MySQL, Oracle, Sqlite |
ssn | sourceServerName | String | Source Server |
sdn | sourceDatabaseName | String | Source Database name |
ddt | destinationDatabaseType | Enum | Destination database type |
ddn | destinationDatabaseName | String | Destination database name |
o | outScriptPath | String | Output path for a single update script file |
Full comparison — all change categories from the script generator.
Inherits all options from SimpleCompare and adds advanced filtering and migration script support.
BaseDiffConsole FullCompare -silent p=D:\Work\Project.bdfJson o=D:\Out\update.sql
Reads database structure and writes it to a single JSON file.
| Alias | Type | Description |
|---|---|---|
o | output | String | Output JSON file path REQUIRED |
dt | databaseType | Enum | Database type (MSSQL, PostgreSQL, etc.) |
sn | serverName | String | Server Name |
dn | databaseName | String | Database Name |
l | login | String | Login |
pass | password | String | Password |
Compare two databases described by JSON schema files.
BaseDiffConsole JsonCompare sjson=D:\schema-prod.json djson=D:\schema-stg.json sdt=MSSQL ddt=MSSQL
| Value | Meaning |
|---|---|
-1 | Unhandled exception (error). The process failed. |
0 | Success. No differences found (for Compare commands). |
> 0 | Success. The value represents the number of differences found. |
BaseDiffConsole FullCompare -silent \ sdt=MSSQL ssn=127.0.0.1 sa=MicrosoftSqlServer sl=sa spass=secret sdn=SourceDB \ ddt=MSSQL dsn=127.0.0.1 da=MicrosoftSqlServer dl=sa dpass=secret ddn=TargetDBExport and then compare JSON:
BaseDiffConsole DownloadSchema o=prod.json dt=MSSQL sn=prod-sql a=MicrosoftSqlServer l=user pass=pw dn=App BaseDiffConsole DownloadSchema o=stg.json dt=MSSQL sn=stg-sql a=MicrosoftSqlServer l=user pass=pw dn=App BaseDiffConsole JsonCompare sjson=prod.json djson=stg.json sdt=MSSQL ddt=MSSQL