Edition Comparison

Edition Comparison

Main modes
Executing SQL queries and scripts
Exporting database data and converting web and text data to text
Exporting database data to CSV, HTML, XML, and JSON
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 in 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.

Trial Version

You can use the gsqlcmd free edition after installation for free.

We recommend testing usage examples of the download package first.

You can activate the trial version to test gsqlcmd Enterprise features during a 15-day trial period for free.

When the trial period expired, you have the following options:

  1. To continue using the gsqlcmd free edition.
  2. To purchase a license and register the gsqlcmd Personal, Standard, or Enterprise edition.
  3. To purchase a subscription and register the gsqlcmd Personal, Standard, or Enterprise edition.
  4. To stop the use and remove gsqlcmd from a computer.

See also