gsqlcmd Edition Comparison
| Feature | Free | Standard | Enterprise | |
|---|---|---|---|---|
| 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 | up to 5 rows | ✓ | ✓ | |
| Importing data from the web and files to databases | up to 5 rows | ✓ | ✓ | |
| Importing data from a database to database using a single command | x | x | ✓ | |
| Synchronizing database data | x | ✓ | ✓ | |
| Making INSERT, UPDATE, MERGE and DELETE commands | up to 5 rows | ✓ | ✓ | |
| Editing database contents using the /toFiles and /fromFiles options | up to 5 rows | ✓ | ✓ | |
| 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, DB2, MySQL, PostgreSQL, NuoDB, Snowflake | ✓ | ✓ | ✓ | |
| SQLite, SQL Server Compact, DBF, FoxPro, Excel | ✓ | ✓ | ✓ | |
| Plain text, CSV, HTML, XML, JSON | ✓ | ✓ | ✓ | |
| Licensing | ||||
| Commercial use | ✓ | ✓ | ✓ | |
Free Edition
The free gsqlcmd edition has a limit of five rows in production modes.
You can activate the trial version to test the Enterprise edition features.
The free edition does not have limitations on executing SQL scripts, text output, downloads, and utility modes.
Standard Edition
The Standard edition has all the features except for data sources and task files based on the <connection>::<query> feature.
In several cases, you can solve this by exporting and importing CSV files.
Enterprise Edition
The Enterprise edition has all the features.
You might choose it if you need to synchronize data across databases.