gsqlcmd Edition Comparison

gsqlcmd Edition Comparison

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 JSONup to 5 rows
Importing data from the web and files to databasesup to 5 rows
Importing data from a database to database using a single commandxx
Synchronizing database datax
Making INSERT, UPDATE, MERGE and DELETE commandsup to 5 rows
Editing database contents using the /toFiles and /fromFiles optionsup 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>xx
Utility modes
make-fmt, make-create, make-ace, make-bulk, make-ini, make-select
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
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.