SaveToDB Edition Comparison

SaveToDB Edition Comparison

FeatureFreePersonalStandardEnterprise
Loading data
Loading data from database tables, views, and stored procedures
Loading data from the web and text files (XML, JSON, CSV, HTML, plain text)
Loading data from Excel workbooks, CSV, and DBF
Saving data
Saving data from Microsoft Excel to SQLite and SQL Server Compact
Saving data from Microsoft Excel to server databasesx
Saving data from Microsoft Excel to server databases using cell change handlersxx
Saving data using VBAx
Saving data to OData web servicesx
Saving data to CSV, HTML, and SQL INSERT files
Creating Outlook tasks, appointments, and emails
User interface features
Customizable Reports tab (SaveToDB 9.0 or higher)
Customizable ribbon actions and Excel's context menu
Ribbon Query List
Ribbon parameters
Table views within Excel
Loading Excel table formats from a database
Auto-filter rows, double-click calendars, and other Excel enhancements
Task panes
Context task panes for data tables, HTML, XML, and images
Cell Editor, List Editor, Row Editor
Wizards
Connection Wizard, Publish Wizard, and Data Merge Wizard
Table Format Wizard
Developer Tools
Application Installer and Application Workbooks
Customizable features
SaveToDB Frameworks
Saving changes to SQLite and SQL Server Compact
Saving changes to server databasesx
Application objects based on SQL codes and web requests
Server-side handlers except for the cell change handlers
Server-side cell change handlersxx
Dynamic Excel validation lists from a database
Dynamic ribbon parameter values from a database
Saving Excel formulas in a database
Data translation except for dynamic columns
Dynamic column translation for multi-tenant applicationsxxx
Application workbooks from a database
Using the add-in as a VBA library
Supported database platforms and data sources
SQL Server, Oracle, DB2, MySQL, PostgreSQL, NuoDB, Snowflake
SQLite, SQL Server Compact
CSV (via ODBC and OLE DB), DBF, FoxPro, Excel (SaveToDB 9.0 or higher)
Plain text, CSV, HTML, XML, JSON from files and web resources
Licensing
Commercial usex

Here is a sample of the cell change handler:

CREATE PROCEDURE [xls17].[usp_sales_change]
    @column_name nvarchar(255) = NULL
    , @cell_value nvarchar(255) = NULL
    , @cell_number_value int = NULL
    , @id int = NULL
AS
BEGIN

SET NOCOUNT ON

IF @column_name = 'licensee'
    BEGIN
    UPDATE dbo17.sales SET licensee = @cell_value WHERE id = @id
    RETURN
    END

IF @column_name = 'product_id'
    BEGIN
    UPDATE dbo17.sales SET product_id = @cell_number_value WHERE id = @id
    RETURN
    END

END

The add-in calls such handlers on every cell change.

The cell change handlers can use the predefined parameters like @column_name, @cell_value, or @cell_number_value, and the named parameters with the column names like @id.

The cell change handlers can update underlying tables or raise exceptions to prevent cell changes.

Trial Version Limitations

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

It does not require the activation.

You may activate the trial version anytime once to test features of the SaveToDB Enterprise edition during 30 days.

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

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

See also: