gsqlcmd Edition Comparison
| Feature | Free Edition | Standard Edition | Enterprise Edition | |
|---|---|---|---|---|
| Main modes | ||||
| Executing SQL queries and scripts | ✓ | ✓ | ✓ | |
| Exporting database data to plain text, CSV, HTML, XML, and JSON | ✓ | ✓ | ✓ | |
| Converting web and text data to plain text | ✓ | ✓ | ✓ | |
| Converting web and text data to CSV, HTML, XML, and JSON | ✓ | ✓ | ✓ | |
| Importing data from the web and files to databases | ✓ | ✓ | ✓ | |
| Importing data from one database to another using a single command | x | x | ✓ | |
| Synchronizing database data | x | ✓ | ✓ | |
| Making INSERT, UPDATE, MERGE, and DELETE commands | ✓ | ✓ | ✓ | |
| Editing database contents using the /toFiles and /fromFiles options | ✓ | ✓ | ✓ | |
| Downloading files | ✓ | ✓ | ✓ | |
| HTTP authentication (Basic, Windows, Forms, OAuth1, OAuth2) | ✓ | ✓ | ✓ | |
| Advanced options | ||||
| Text and CSV task files | ✓ | ✓ | ✓ | |
| Getting tasks from databases using <connection>::<query> | x | x | ✓ | |
| Utility modes | ||||
| make-fmt, make-create, make-ace, make-bulk, make-ini, make-select | ✓ | ✓ | ✓ | |
| get-schema | ✓ | ✓ | ✓ | |
| create-database | ✓ | ✓ | ✓ | |
| edit-connections, show-connections, show-connection, show-providers | ✓ | ✓ | ✓ | |
| show-roots, show-html-tables, clean-html | ✓ | ✓ | ✓ | |
| del-if-html, del-if-empty | ✓ | ✓ | ✓ | |
| sleep, hide-window, show-window, minimize-window, restore-window | ✓ | ✓ | ✓ | |
| Supported database platforms and data sources | ||||
| SQL Server, Oracle, MySQL, PostgreSQL, Snowflake | ✓ | ✓ | ✓ | |
| SQLite, DBF, FoxPro, Excel | ✓ | ✓ | ✓ | |
| Plain text, CSV, HTML, XML, JSON | ✓ | ✓ | ✓ | |
| Licensing | ||||
| License | MIT | EULA | EULA | |
| Commercial use | ✓ | ✓ | ✓ | |
Free Edition
The free gsqlcmd edition limits you to five rows in production modes.
You can activate the trial version to test the Enterprise edition features.
There are no limitations on executing SQL scripts, text output, downloads, or utility modes in the free edition.
Standard Edition
The Standard edition includes all features except for data sources and task files based on the <connection>::<query> feature.
In many cases, you can work around this by exporting and importing CSV files.
Enterprise Edition
The Enterprise edition includes all features.
Consider this edition if you need to synchronize data across databases.