SaveToDB 7 Version History

SaveToDB 7 Version History

Version 7.29, November 29, 2018

New features:

  • New @json_values_f2 parameter allows getting Excel table row data as a JSON object.
    You may use it instead of @json_column and @json_values that get data as JSON arrays.
  • VBA Version property.

Improvements:

  • Improved performance of pasting data in Microsoft Excel.
    For example, pasting 100 000 rows takes less than a second.
  • Improved performance of reloading data and configuration.
    The add-in caches and does not reload database configuration tables.
    Close and reopen the workbook when you add new configuration tables to a database.
  • JSON parameters like @json_column or @json_values do not include _RowNum and fields with the DoNotSave handlers.
  • New @json_values_f1 as a @json_values synonym.

Bug Fixes:

  • Fixed issues with non-actual servers and databases in the connection wizards.
  • Fixed issues with long timeouts in the connection wizards.
  • Fixed issues with QueryTable exceptions.

Version 7.28, November 7, 2018

New features:

  • The Start, All Programs, SaveToDB folder includes the Installation Diagnostic Tool, DiagTool.exe.
    The tool allows diagnosing and fixing installation issues.
  • Edit procedures may use new context parameters:
    @JsonColumns or @json_columns - an array of Excel table column names;
    @JsonValues or @json_values - an array of Excel table row values;
    @EditAction or @edit_action - an operation type: INSERT, UPDATE, DELETE, or MERGE;
    These parameters with the @TableName or @table_name parameter allow creating generic INSERT, UPDATE, DELETE and MERGE procedures.
  • Edit procedures may use new context parameters:
    @ChangedRowCount or @changed_row_count - a number of changed rows in the transaction;
    @ChangedRowIndex or @changed_row_index - a row index in the transaction.
    These parameters allow identifying the first and last operations to execute initial and final actions in the transaction.
  • The connection wizards save successful connection strings in the cache file and suggest such connections next time.
    Before this, the wizards used connections of the active workbook only.
    The cache file is encrypted. It is located at
    C:\Users\<username>\AppData\Local\Gartle\Connections\savetodb.dll.config.
    This file cannot be read by other users or by the same user on another machine.
    You may open and edit cached connections using the Open Connection Cache button at the Developer tab in the Options dialog box.

Improvements:

  • The add-in supports more data types that can be used with the SELECT * statement with no additional casting.
  • The add-in casts Microsoft SQL Server date and time types in the same way independently on a used provider or driver:
    DateTime and DateTime2(0) are of Excel date types;
    Time(0) is of Excel time type (with date 0);
    DateTime2(n), Time(n) and DateTimeOffset2 are always strings.
    The add-in can save up to 7 fractional second digits.
  • The add-in casts binary(16) and char(36) to the GUID (uniqueidentifier) type.
    You may use these types, for example, with MySQL and SQLite that have no built-in GUID type.
    If a GUID field is a primary key, then the add-in generates GUID values for new rows automatically.
    The add-in does not generate values for Microsoft SQL Server if the field has the default value, for example, newid().
    The add-in counts such fields as IDENTITY.
  • The add-in supports the HHH:mm:ss MySQL time format.
  • The add-in supports the geography and geometry Microsoft SQL Server data types including saving changes.
  • The add-in includes SQLite 3.24.0.
    The new version supports UPSERT commands.
  • The ContextMenu and SelectionChange handlers have improved behavior for related queries.
    If the TARGET_WORKSHEET field contains the _NEW value, the add-in asks an insert address and only once. It does not create a new sheet every time.
    So, using the _NEW value is the best option to create related queries on other sheets.
    The add-in unhides hidden sheets if required.
    Developers may define several SelectionChange handlers for a single object.
  • The DoNotSave handler with an empty COLUMN_NAME field disables merge operations also.
  • Default format and validation rules improved.
    The add-in does not add validation rules for fields with ValidationList or SelectionList handlers.
    The add-in does not add date formats and validation rules for date and time data types with fractional seconds like datetime2(3) or time(3).
    The add-in does not add date formats and validation rules for data types with time zones like datetimeoffset.
  • The add-in suppresses the sort warning message of Microsoft Excel.
  • The HTML form allows opening HTTP, HTTPs, and mailto hyperlinks.
    The form saves and restores the size and position.
    The form disables the context menu and navigating and refresh shortcut keys.
  • The Check SQL and Check Merge SQL forms have improved behavior.

Bug Fixes:

  • Fixed bug with empty values of nvarchar(max), varchar(max), and XML columns loaded through SQL Server ODBC Driver 11/13/17.
    This is a bug of Microsoft Excel (2007/2010/2013/2016).
    The add-in casts such columns to ะบ ntext during the connection: CAST([<field>] AS ntext) AS [<field>]
  • Fixed bug with converting validation list values in merge operations.
  • Fixed bug with unstable freezing windows on restoring table formats.

Version 7.27, September 17, 2018

Bug Fixes:

  • Fixed conversion of SQL Server date type values to dates on filtered ranges.

Version 7.26, September 10, 2018

New features:

  • Support for Azure SQL Data Warehouse.
  • Support for tables with headers turned off.
    Note, if you create forms with such headers, update all SaveToDB installations to SaveToDB 7.26.

Improvements:

  • The add-in calls the INSERT procedures even for empty rows with the changed @rownum parameter value.
    This guarantees that your app gets the list of all rows with changed numbers.
  • Improved support for ODBC driver errors.
  • You may use the DoNotSave handlers to disable saving values of formula fields in the reload phase.
    Otherwise, the add-in saves the values of the formula columns to check for row changes before saving.

Bug Fixes:

  • Fixed bug on fields with special characters: .,;:'"`~+-*\/|<>[](){}=@%!?&#$
  • Fixed bug on inserting tables with RC address style.
  • Fixed bug of loading values started with a single quotation mark.

Version 7.25, July 25, 2018

Improvements:

  • Significantly improved speed of loading large datasets from MySQL and PostgreSQL.
    For example, it loads 400k records four times faster (about 10 seconds).

Version 7.24, July 11, 2018

Bug Fixes:

  • Fixed exception on adding form fields.

Version 7.23, June 22, 2018

The free SaveToDB Express edition is no longer available.

Existing users of the free edition may continue use it.

Version 7.22, June 18, 2018

Bug Fixes:

  • Fixed issues with the "Member not found" exception related to Sort and AutoFilter objects in Excel version 16.0.10228.20021.

Version 7.21, May 25, 2018

Improvements:

  • Improved JSON parser
  • Product Registration Wizard uses HTTPs

Bug Fixes:

  • Fixed SendFailure error with HTTPs TLS 1.2

Version 7.20, May 24, 2018

Improvements:

  • Updated Product Registration Wizard

Version 7.19.3, March 26, 2018

Improvements:

Bug fixes:

  • Fixed compatibility issues with PowerPivot.
  • Fixed issues with deleting named cells.

Version 7.19.2, March 21, 2018

Improvements:

  • Update SQLite .NET Provider 1.0.108.0
  • Improved detecting next page links in HTML pages.
  • Converting dates in the "dd MMM yyyy" format from text and web data sources to dates.

Bug fixes:

  • Fixed installation issues.
  • Fixed error messages on connecting SQLite databases with passwords.
  • Fixed compatibility issues with PowerPivot.

Version 7.19, March 12, 2018

Breaking changes:

  • The add-in uses Excel validation lists to convert id to names.
    The behavior is the same as for ValidationList event handlers configured in a database.
    For example, if you specify a validation list as a table with two columns like ID and NAME, then the add-in replaces ID values to NAME values.
    To prevent converting, use validation lists with one column.
  • The add-in converts IDs to names for columns with SelectionList handlers if the source list has two columns.
    So, now SelectionList and ValidationList handlers have the same features except the add-in does not add Excel validation lists to SelectionList columns.
    To prevent converting of column values, specify SelectionList queries with one column results.

Improvements:

  • SaveToDB Framework 7.19.
    The framework includes redesigned upgrade packages.
    The framework for Microsoft SQL Server removes users from the framework roles on uninstalling.
    The batch files allow executing from protected folders and read-only media.
  • Improved Workbook Information dialog box.
    It saves and restores last user settings.
  • Fields HANDLER_CODE and SELECT_CODE based on tables and views allow using functions.
    For example, a query with YEAR([Date]) selects a unique list of years.

Bug fixes:

  • Fixed bug of incorrect column orders of validation list values from tables.
  • Fixed bug of the Save Query As action for tables without connections.
  • Fixed bug of creating validation lists based on tables with dashes in names.

Version 7.18, February 21, 2018

Improvements:

  • Improved speed of converting formulas in filtered tables.
  • Ignoring new SaveToDB 8 handler types.

Bug fixes:

  • Fixed System.OverflowException with MySQL.
  • Fixed translations of columns with case differences only.

Version 7.17, February 7, 2018

Improvements:

  • Updated Product Registration Wizard.
  • The UserAgent header contains the default value: SaveToDB.

Bug fixes:

  • Fixed converting text formulas in hidden rows.

Version 7.16, January 15, 2018

Improvements:

  • Updated SaveToDB SDK 7.16.
  • Updated SaveToDB Framework 7.16 for Microsoft SQL Server.
  • SQL Server and SQL Server Compact objects can use parameters of timestamp and rowversion types.
  • Event handlers can use the _rownum parameter to get row numbers independently on the Excel UI language.
  • The add-in does not apply default formatting to read-only fields.
  • The add-in does not apply default formatting and validation to fields of the datetimeoffset type.

Bug fixes:

  • Fixed possible issues with fields and parameters that contains non-alpha-numeric characters in SQL Server.
  • Fixed possible stability issues with Excel 2013-2016.
  • Fixed possible issues with pivot tables.
  • Fixed issues with loading SQL Server Compact configurations (7.15 only).
  • Fixed issues with inserting a new connected table on another worksheet.
  • Fixed ignoring last column values in table fields.
  • Fixed removing leading zeros in fields of variant types.
  • Fixed exceptions with converting TimeSpan to DateTime in the cell_date_value parameter.
  • 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 7.15, November 27, 2017

Breaking changes:

  • The add-in does not protect cells with more than 32767 characters.
    Now it generates the simple code like SELECT * FROM <table> for tables with column data types like varchar(max), string, text, or CLOB.
    You may exclude fields with longer values in Excel directly.

Improvements:

  • The add-in restores ribbon fields for tables and views with the query list.
  • The add-in restores worksheet tab colors for newly connected tables using stored formats in a database.
  • The SQL execute wizard allows changing a transaction mode.

Bug fixes:

  • Fixed configuration loading for Microsoft SQL Server 2005.
  • Fixed configuration loading for Microsoft SQL Server 2000.
  • Fixed SQL parameter configuration loading for Microsoft SQL Server.
  • Fixed SQL parameter configuration loading for parameters with brackets used in the HANDLER_CODE and SELECT_CODE fields.
  • Fixed loading parameter values with leading spaces in the HANDLER_CODE and SELECT_CODE fields for the VALUES type.
  • Fixed showing procedure parameter values at the ribbon for Oracle Database.
  • Fixed loading SQL parameter values at the ribbon for Oracle Database.
  • Fixed losing the List Editor task pane after adding rows.
  • Fixed showing exception messages on unlocking workbooks.

Version 7.14, November 8, 2017

New features:

  • New Change Tracking Framework for SQL Server.
    You may download, install, and use the framework for free with the SaveToDB Express.
    You may download the Change Tracking Framework for SQL Server e-book.
  • SelectionChange and ContextMenu handlers in task panes.
  • Configuring event handlers for event handlers.
  • Configuring parameters of SQL codes like stored procedure parameters.
  • Configuring translation of object and column names for _taskpane event handlers.
  • Task pane context menu to hide table columns.

Improvements:

  • The data language list in SaveToDB Options includes languages that may use the international keyboard layout (De, Es, Fr, It, Sv, Ja, Zn).

Bug fixes:

  • Converting parameters to values in SQL codes like @param= @param.
    Remove spaces before the equal sign to keep the parameter name as is.
  • Converting '= NULL' to 'IS NULL' in SQL codes used to execute stored procedures.

Version 7.13, November 3, 2017

New features:

  • New ready-to-use planning application with Microsoft Excel and SQL Server.
    You may download, install, and use the application for free.
    You may find example workbooks in the Wizards, Workbook Templates and Examples menu also.
    You may download the Planning Application with Microsoft Excel and SQL Server e-book.
  • Edit procedures may use the json_columns and json_values parameters to get all table columns and row values in JSON arrays.
    This feature allows implementing procedures to save changes in dynamic tables.

Improvements:

  • Updated examples in the Wizards, Workbook Templates and Examples menu.
  • You may hold Ctrl to reset authorization for HTTP requests.
  • Event handlers with the _reload option reload validation lists also.
  • Added JSONP parser.
  • Added PartialHTML parser (HTML inside JSON and JSONP).
  • Improved HTML parser.
  • Edit procedures may use the TableName and table_name parameters like event handlers.

Bug fixes:

  • Error converting string values to dates and numbers for variant types.
  • Losing conditional formattings for queries with errors in SQL codes.
  • Losing conditional formattings after AccessViolationException.
  • Errors with HTTPS requests that support tls12 only.
  • Parser errors for quotes in JSON.
  • NullReferenceException while loading bad event handler configurations.
  • Incomplete value lists in Oracle Database.
  • Registration wizard WebException in the offline mode

Version 7.12, September 7, 2017

New features:

  • Rotating values of Icon Sets on double-clicks.
    This feature allows implementing CheckBoxes in Excel.
    Use numbers to define ranges, not percents.

Bug fixes:

  • Losing ValidationLists on creating detail queries on worksheets.
  • Issues with saving OData data due to bad relative EditLinks.
  • Double requests for OData with basic authentication.

Version 7.11, August 23, 2017

Bug fixes:

  • Issues with Save All Sheet Tables.

Version 7.10, August 22, 2017

Bug Fixes:

  • Issues with registering products.
  • Issues with loading OData models.
  • Issues with decoding deflate web data.
  • Exception messages on resizing diagram windows.
  • Errors with saving table formats to Microsoft SQL Server databases.
  • Errors with calling Oracle Database procedures.
  • Converting string values to numbers in validation lists.

Version 7.9, August 1, 2017

New features:

  • Azure Active Directory integrated authentication
  • Azure Active Directory password authentication

Improvements:

  • SQL Server date columns are selected as is, without casting to the DateTime type.
    So, the add-in generates SELECT codes like SELECT * FROM <table> for such tables.
    The add-in converts loaded string values in the YYYY-MM-DD format to Excel dates after loading data.

Bug fixes:

  • Issues with connections using DSN.
  • Losing StopIfTrue = False in conditional formats.
  • Exception messages on restoring conditional formats.
  • Exception messages on copying formats for tables with column change handlers.
  • Exception messages on refreshing empty tables with updatable form fields.
  • Exception messages on refreshing pivot tables.

Version 7.8, July 5, 2017

Improvements:

  • Updated registration wizard
  • Updated installer
  • Improved detecting of updatable views for SQL Server
  • Showing columns of historical prices as OHLCV by default

Bug Fixes:

  • Converting IP-addresses to numbers
  • Exception messages on renaming pivot tables

Version 7.7, May 31, 2017

Licensing Changes

  • Removed limit of loading multiple web pages in SaveToDB Express.
  • Removed limit of updatable cursor fields in SaveToDB Express.

New Features:

  • New parameters of XML and JSON parsers:
    CollapsedNodes, SkippedNodes, IgnoredTags, NoSourceHeaders, AsIs, and RowValues

Improvements:

  • Updated set of suggested URLs for loading stock quotes, historical and intraday stock prices, option chains and futures from Yahoo Finance, Google Finance, and MSN Money.
  • Special processing of datetime values of historical prices from MSM Money.
  • Special processing of datetime values of option chains from Yahoo Finance.
  • HTML parser supports multiple tables in the /RootPath option.
  • Possibility to activate the add-in using the activation files in virtual environment.
  • Removed option 'Single Line SQL for SQL Server.' The add-in always generates standard SQL commands.
  • Suppressed error messages when DisplayAlerts = False.
  • Improved documentation.
  • Improved error diagnostics.

Bug Fixes:

  • Missed URLs in the Query Parameters dialog box title.

Version 7.6.2, May 15, 2017

Bug Fixes:

  • Wrong calls of event change handlers on changing headers and deleting rows over the tables (version 7.6 only).

Version 7.6, May 11, 2017

Improvements:

  • Support of ODBC Driver 13 for SQL Server
  • Improved documentation
  • Improved error diagnostics

Bug Fixes:

  • Installer issues with updating previous versions.
  • Lost of ribbon values of context parameters from the Edit Parameters form.
  • Missing calls of cell change event handlers on deleting the last rows.

Version 7.5, May 5, 2017

New Features:

  • Spanish translation

Improvements:

  • Redesigned msi installer.
  • New context parameters of cell change event handlers: @ChangedCellAction and @changed_cell_action.
    The parameters get values: CellChange, RowInsert, and RowDelete.

Bug Fixes:

  • Wrong detection of user-defined types in Microsoft SQL Server.
  • Publish wizard issues for tables without connections.
  • Web connection issues.
  • Incorrect behavior of setting the IsRibbonField property from VBA.
  • Missing calls of cell change event handlers on adding and deleting rows.

Version 7.4, April 5, 2017

Improvements:

  • Improved parsing JSON data.
    The parser supports * as a property name in the rootPath parameters.
    For example, try to load futures data from the Yahoo Finance website using the URL:
    https://query1.finance.yahoo.com/v10/finance/quoteSummary/CK18.CBT?modules=futuresChain;rootpath=quoteSummary.result.futuresChain.futuresChainDetails.*
  • HTML parser converts string values with % to numbers and "n.a." values to empty values.

Bug Fixes:

  • Lost of authorization data of HTTP requests.
  • Lost of rootPath parameter values of HTTP requests.

Version 7.3.2, March 31, 2017

Bug Fixes:

  • Updating non-string ribbon parameters with NULL on changes of parameter named cells.

Version 7.3.1, March 28, 2017

Bug Fixes:

  • Lost of the SaveToDB tab in new installations.
  • Lost of Encrypt and TrustServerSertificate options in the SQL Server .NET provider.

Version 7.3, March 27, 2017

New Features:

  • The add-in supports multiple values in ribbon parameters for tables and views.
    To select multiple values, click on the Query Parameters group button and click on the "..." button to launch a new editor of multiple values.
    Multiple values are translated to the WHERE <field> IN (<value>, ..., <value>) clause.
  • The add-in supports multiple values for string parameters of stored procedures.
    The add-in passed multiples values as (<value>, ..., <value>).
    For example, a select stored procedure has a currency string parameter and a view that populates the parameter values like (1, 'USD'), (2, 'EUR'), (3, 'GBP').
    If a user selects USD only, the add-in calls the procedure with '1'. If the user selects [USD,EUR], the add-in calls the procedure with the '(1,2)' value.
    Be careful with SQL injection using this technique. The best way is to accept integer and date multiple values only, and check the input values like this:
    IF LEFT(@param, 1) = '(' AND RIGHT(@param, 1) = ')' SET @param = SUBSTRING(@param, 2, LEN(@param) - 2)
    IF @param IS NOT NULL AND @param LIKE '%[^-0-9.,'' ]%' SET @param = NULL

Improvements:

  • Improved error diagnostics.

Bug Fixes:

  • Lost of add-in metadata on deleting multiple worksheets with VBA at once.
  • Showing the SaveToDB Enterprise edition as SaveToDB Express in the About Product dialog box.

Version 7.2, March 20, 2017

The trial version requires registration. The trial period remains the same, 30 days.

New Features:

  • The SQL Server Management application to manage logins, users, roles, and permissions in SQL Server and SQL Azure databases.
    You may launch the application from the query list in the Data Connection Wizard.
    The application can be used by database administrators and business users.
  •  Developer Guide 7.2 in the Workbook Templates and Examples menu.
    The guide shows new features for VBA developers.
  • Configuration tables may contain pseudo-SQL codes like
    [+|-][@]<Field>[,...]]
    All fields are used in SELECT.
    Fields with @ are used in WHERE.
    Fields with + or - are used in ORDER BY.
    For example, the code: +Date,+Sum,@Company,Item
    generates the SQL code:
    SELECT Data, Sum, Company, Item FROM <table> WHERE Company = @Company ORDER BY Date, Sum
    This feature simplifies creating drill-down queries for business users.
  • New column event handlers: ConvertFormulas and DoNotConvertFormulas
    For columns with ConvertFormulas, the add-in tries to convert text formulas from a database to Excel formulas.
    This allows having values and configured formulas in the same column.
    For columns with DoNotConvertFormulas, the add-in disables auto-detecting formulas and do not convert them.
  • New methods for using with VBA. Here are groups of new methods:
    - ribbon control;
    - executing queries to databases, web data sources and text files;
    - working with connection strings;
    - protecting usernames and passwords;
    - working with cursors and form fields;
    - working with table views;
    - add-in options.
  • You may choose stored procedure parameters to place to the ribbon.
    It is useful for procedures with more than six parameters.
  • You may specify WHERE field values without placing the fields to the ribbon.
  • The add-in may automatically remove the named cells with error ranges.
    You may disable this option if use macros that fix such errors.

Improvements:

  • Values of the fields that have Formula or FormulaValue handlers are used in the generated SQL even the fields are not selected.
    The best case is using the =UserName() and =NOW() formulas to update the LastUserName and LastModified columns.
    Now such fields have the correct values even the fields are not selected in Excel.
  • Event handlers may use new context parameters, CellDateValue and CellNumberValue.
    The parameters contain datetime and number values if possible or NULL.
  • Form fields can be created on any worksheet. The form fields on other sheets must have a workbook scope.
    Such fields update the underlying table. So, you may use the fields to create edit forms easily.
  • Improved detection of formula columns.
    For such columns, the add-in converts text formulas from a database to Excel formulas.
    You may change the automatic detection using the ConvertFormulas and DoNotConvertFormulas handlers.
  • Improved performance of scrolling on tables with form fields and cursors.
  • Improved Pivot Data Connection Wizard.
    The wizard allows creating multiple pivot tables on a sheet connected to a single data source.
  • Improved messages of the Register Product wizard.

Bug Fixes:

  • SQL execution errors of Change handlers that contain DECLARE statements.
  • Loss of parameter values in the Parameter Editor form.
  • Generating UPDATE commands in the merge mode for a table without fields for UPDATE.
  • Loss of sort orders after refreshing tables with ValidationList handlers.
  • Loss of ribbon fields after connection string change using VBA.
  • Loss of date validations that starts at 1/1/1900.
  • Absent English in the Data Language list if the English keyboard layout is not installed on Windows.
  • Detecting tables with INSTEAD OF triggers like as TRIGGERED VIEWs.
  • Detecting CSV data with one column as text.
  • Detecting JSON data with two-dimensional arrays as text.

Version 7.1.1, February 9, 2017

Bug Fixes:

  • Fixed issues with Data Merge Wizard.
  • Fixed issues with cursor fields.

Version 7.1, February 3, 2017

New Features:

  • Ribbon parameters may get values from Excel ranges.
    Set the RANGE type in the SELECT_TYPE field and a range name or address in the SELECT_CODE field.
  • Ribbon parameters may get values specified in the SELECT_CODE field directly.
    Set the VALUES type in the SELECT_TYPE field.
  • You may specify field names used to select ribbon parameter values from tables and views in the SELECT_CODE column.
    This feature allows getting values without SQL code use.
  • ValidationList and SelectionList may get values from Excel ranges.
    Set the RANGE type in the HANDLER_TYPE field and a range name or address in the HANDLER_CODE field.
  • ValidationList and SelectionList may get values specified in the HANDLER_CODE field directly.
    Set the VALUES type in the HANDLER_TYPE field.
  • You may specify field names used to select ValidationList and SelectionList values from tables and views in the HANDLER_CODE column.
    This feature allows getting values without SQL code use.
  • The Wizards, Workbook Templates and Examples menu and SaveToDB SDK include Developer Guide 7.1.
    The new guide shows how to create Excel application using new SaveToDB 7.1 features, without SQL or VBA use. Try it.

Improvements:

  • The add-in uses ribbon parameter and named cell values for new row cells protected by DoNotChange handlers.
    Such cells had NULL values before.
  • The Copy and Insert Rows button copies values protected by DoNotChange handlers.
  • You may disable DoNotChange handlers in macros. Set Application.DisplayAlerts = True.

Bug Fixes:

  • Fixed inserting rows instead of updating in SQL Server in some cases. The bug was added in SaveToDB 7.0.
  • Fixed error messages on selecting the entire worksheet with the active List Editor.
  • Fixed bad values calculated by the =UserName() and =DomainUserName() functions.

Version 7.0.3, January 25, 2017

Bug Fixes:

  • Fixed issues with creating SQLite databases.
  • Fixed issues with List Editor.
  • Fixed issues with saving table formats to SQL Server.

Version 7.0.2, January 20, 2017

Bug Fixes:

  • Fixed issues with PowerQuery compatibility.
  • Fixed issues with Query Lists.

Version 7.0.1, January 17, 2017

Bug Fixes:

  • Fixed issues with MySQL ODBC drivers.

Version 7.0, January 17, 2017

Licensing Changes

  • The free SaveToDB Express edition is available again.
    However, the new Express edition has other limits than previous versions. See Edition Comparison.
  • Starting SaveToDB 7, major upgrades are not free.
    You may purchase and renew Upgrade Warranty of free upgrading to the latest major versions.
  • As a special case, customers, who bought SaveToDB 6.x versions, may upgrade to SaveToDB 7 for free, using the same product codes.
    Customers, who bought SaveToDB 1.x-5.x versions, may purchase an upgrade license.
  • The SaveToDB add-in is available as a subscription.
    During the subscription period, you may upgrade to the latest versions for free.
  • The SaveToDB Personal edition allows saving OData data.
    So it has the same features as the SaveToDB Enterprise edition.

Upgrade Notes

  • Previous versions are converted to a new trial version with a 30-day period.
  • Customers, who bought SaveToDB 6.x versions, may register SaveToDB 7 for free, using the SaveToDB 6.x product codes.
  • Customers, who bought SaveToDB 1.x-5.x versions, may purchase an upgrade license and register SaveToDB 7, or uninstall SaveToDB 7.0 and install the previous version.
    In the last case, you may continue to use the previous registered version without additional actions.
  • Customers, who use free SaveToDB Express 1.x-5.x versions, may purchase a full license or subscription and register SaveToDB 7, or uninstall SaveToDB 7.0 and install the previous version.
    In the last case, you may continue to use the previous registered version without additional actions.
  • SaveToDB 7.0 supports all previous versions of server-side configurations.
    So, you do not need to change your databases before the upgrade.
  • You may upgrade previous versions of SaveToDB Framework to the newest SaveToDB Framework 7.0.
    SaveToDB SDK contains upgrade SQL codes for all database platforms.

Download Package Changes

  • The SaveToDB 7 setup package does not include gConnectionManager, gsqlcmd, and gwebcmd.
    You may install these products using separate setup packages.

New features:

  • SaveToDB supports working with SQLite databases.
    SQLite is the best database platform for creating personal Microsoft Excel applications using the SaveToDB add-in.
    SQLite database files can be located in workbook folders, and data can be loaded to multiple workbooks and worksheets in different views.
    The free SaveToDB Express edition has no limits and delays for both SQLite and Microsoft SQL Server Compact databases.
    However, SQLite supports views, and Microsoft Excel supports connecting to SQLite via ODBC drivers.
  • The SaveToDB add-in may read server-side configurations from tables like from views.
    This feature allows creating database applications in a single schema, with data and configuration tables, without using SaveToDB Framework.
    You may create required configuration tables and views using SaveToDB Framework source codes just replacing schemas.

Improvements:

  • The latest SaveToDB Framework 6.9 and 6.10 are renamed to SaveToDB Framework 7.0.
    SaveToDB Framework 7.0 includes updated batch files.
    SaveToDB Framework Installer allows installing the latest SaveToDB Framework 7.0 only.
  • SaveToDB SDK 7.0 includes new examples for SQLite and updated examples for other database platforms.
  • The updated SaveToDB installer creates menus in Windows 8 and Windows 10 styles.
  • Significantly improved performance of executing MySQL commands.
  • The SQL Debug mode has been removed.
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.