Version History

Version History

Version 5.0, February 7, 2019

New features:

  • gsqlcmd supports connections to Microsoft Excel workbooks using the ODBC drivers and OLEDB providers.
  • gsqlcmd supports connections to DBF and FoxPro files.
  • gsqlcmd has a new Show mode to show connection data.
  • gsqlcmd has a new Version mode to show and check the app version.

Version 4.19, February 7, 2019

Improvements:

  • Updated examples
  • Support to USE commands with Azure SQL Database

Bug fixes:

  • Fixed rollback on failed transactions (starting 4.17).

Version 4.18, December 21, 2018

gsqlcmd moved back to www.gsqlcmd.com from www.savetodb.com.

New features:

  • New user installer allows installing the tool without administrator privileges.

Improvements:

  • SQL queries with the /fromFiles option may omit the @filename parameter if the /fromFiles option contains an existing file name.
    For example, here is a command that updates a Joomla custom module using the cmd-style.min.css content at the gsqlcmd.com website:
    gsqlcmd gsqlcmd.com "UPDATE jos4_modules SET content = :text WHERE title = 'Land - Style' AND module='mod_custom'" /fromFiles=_min\cmd-style.min.css

Version 4.17, November 7, 2018

Improvements:

  • Improved connection wizard.
  • Updated SQLite 3.24.0.
    The new version supports UPSERT commands.

Version 4.16, September 25, 2018

New features:

  • Support for Snowflake

Improvements:

  • Updated gConnectionManager 3.8

Version 4.15, September 10, 2018

New features:

  • Support for Azure SQL Data Warehouse

Improvements:

  • Updated gConnectionManager 3.7

Bug fixes:

  • Fixed issues with special characters in column names.
    The successfully tested set includes characters: .,;:'"`~+-*\/|<>[](){}=@%!?&#$

Version 4.14, July 25, 2018

New features:

  • The monthly subscription is available.
  • The product tries to activate a new subscription in a period three days before and three days after the expiration.
    It sends request automatically every 16 hours. You may disable this feature in the finish step of the registration wizard.

Version 4.13, June 22, 2018

Improvements:

  • Updated Product Registration Wizard

Version 4.12, May 24, 2018

Improvements:

  • Updated Product Registration Wizard

Version 4.11, February 21, 2018

New features:

  • The FirstRow parameter allows setting the first data row in an input CSV.
  • The InputDateFormat parameter allows setting input date formats like DMY or MDY.
  • The OutputCulture parameter allows setting output regional settings.
    For example: OutputCulture=en-GB

Improvements:

  • The 'Generating SQL Server Install Scripts' application includes updates for SaveToDB Framework 8.

Bug fixes:

  • Fixed System.OverflowException with MySQL.

Version 4.10, February 7, 2018

Improvements:

  • Updated Product Registration Wizard

Version 4.9, January 15, 2018

New features:

  • The Skype Reports example shows how to import Skype calls into a SQL Server database.

Improvements:

  • The utility uses the new line characters from the templates if possible.

Bug fixes:

  • Fixed removing leading zeros in fields of variant types.
  • Fixed exceptions with converting 0000-00-00 00:00:00 to dates in MySQL if Allow Zero Datetime=False or Convert Zero Datetime=False.

Version 4.8, December 21, 2017

Bug fixes:

  • Fixed issues with removing leading zeros from string values

Version 4.7, November 3, 2017

Bug fixes:

  • Registration wizard WebException in the offline mode

Version 4.6, August 22, 2017

Breaking changes:

  • Changed .NET platform from .NET Framework 4.0 Client Profile to .NET Framework 4.5.2.
  • Changes in requirements for Windows 7, Windows Server 2008, and Windows Server 2008 R2.
  • Removed support of Windows XP.
  • Removed support of SQL Server 2000.
  • Removed support of MySQL 5.0, 5.1, 5.2.
  • Removed support of MariaDB 5.1, 5.2, 5.3.

Bug Fixes:

  • Issues with registering products.

Version 4.5, August 1, 2017

New features:

  • Azure Active Directory integrated authentication
  • Azure Active Directory password authentication
  • /NoBOM option to suppress adding BOM to output

Improvements:

  • The application for generating SQL Server install scripts uses utf-8 encoding

Version 4.4, July 5, 2017

New features:

  • Register mode

Improvements:

  • Updated registration wizard
  • Updated installer

Bug Fixes:

  • Converting IP-addresses to numbers

Version 4.3, May 31, 2017

New features:

  • New functions of the /add and /set options: FileNameDateTime(), FileNameDate(), and FileNameTime().
  • New options to export values to text files and import values from the text files: /toFiles and /fromFiles=<mask>
    For example:
    gsqlcmd website.com "SELECT alias, content FROM content" content\alias.htm /toFiles /outputCodepage=65001
    gsqlcmd website.com "UPDATE content SET content = @text WHERE alias = @filename;" /fromFiles=content\*.htm
    See usage in the new 'Website Content Editor' example.
  • New usage examples:
    Website Content Editor
    Website CSV Editor

Improvements:

  • Updated gConnectionManager 3.3

Bug Fixes:

  • Skipped empty values in the columns added using the /add option.
  • Ignored specified date and time formats for data with multiple date and time columns.

Version 4.2, May 11, 2017

Licensing changes

Improvements:

  • Rewritten and redesigned documentation
  • Updated installer
  • Removed portable package
  • Support of ODBC Driver 13 for SQL Server
  • Updated gConnectionManager 3.2

Bug Fixes:

  • Detecting wrong data types for user-defined types in SQL Server

Version 4.1, February 3, 2017

Bug Fixes:

  • Fixed possible issues with detecting primary keys in SQL Server.
    The bug was added in gsqlcmd 4.0.

Version 4.0.3, January 25, 2017

Bug Fixes:

  • Fixed issues with creating SQLite databases

Version 4.0, January 17, 2017

You may upgrade previous versions to gsqlcmd 4.0 for free.

New features:

  • gsqlcmd supports SQLite databases.
  • The CreateSQLite3 mode allows creating new SQLite database files.
  • The /keys option allows defining fields used instead of primary key fields in INSERT, UPDATE, and DELETE commands.
    You may use this option, for example, to synchronize data between different databases using fields like email or SSN instead of identity fields.
  • gsqlcmd is available as a subscription.

Improvements:

  • Updated gConnectionManager 3.0
  • Significantly improved performance of executing MySQL commands
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.