SaveToDB Edition Comparison

SaveToDB Edition Comparison

SaveToDB is a powerful add-in for working with databases and the web in Microsoft Excel, and a powerful platform for Microsoft Excel application development.

Personal and Enterprise editions have the same features but different prices and licenses.
Using the SaveToDB Personal edition in companies and organizations is prohibited.

The free SaveToDB Express edition has nearly the same features except handling Excel cell change events using stored procedures and SQL codes.
Handling cell change events is the required component of corporate applications.

Also, the SaveToDB Express edition has a delay during saving changes to a database or OData services.
Such delay is a better solution than complete disabling of this feature as it was in the previous versions.
We hope to see you as our customer if you use this feature frequently.

There are no delays for saving data to SQLite and SQL Server Compact databases, and for calls from VBA macros.
Also, cell change event handlers are available in SaveToDB Express for SQLite and SQL Server Compact databases.

So, you may use the SaveToDB add-in as a free platform for personal applications and as a free data layer library for corporate VBA applications. 

FeatureExpressPersonalEnterprise
Loading Data   
Loading data from database tables, views, and stored procedures
Loading data from web pages and web services (HTML, CSV, XML, JSON, plain text)
Automatic loading multiples web pages (HTML, XML, JSON)
Loading data from OData data sources
Loading data from text files (HTML, CSV, XML, JSON, and plain text)
Saving Data   
Saving data from any data source to a database using built-in proceduresDelayed
Saving data from any data source to a database using Publish Wizard
Saving data from any data source to a database using Data Merge Wizard
Saving data from any data source to a database using custom event handlersx
Saving data from any data source to a database using custom SQL codeDelayed
Saving data from any data source to a database using custom stored proceduresDelayed
Saving data from any data source to a text file (CSV, HTML)
Saving data to OData servicesDelayed
Querying Data   
Changing queries using the ribbon Query List
Changing stored procedure parameters using the ribbon Query Parameters
Changing select where fields using the ribbon Query Parameters
Changing web-query parameters using the ribbon Query Parameters
Changing data table views using the ribbon Table View list
User Interface Features   
Editing Excel tables using pivot tables
Saving and restoring Excel table views
Saving and restoring pivot table views
Selecting active table rows (cursors)
Updating named cells with active table row values and back (fields)
Showing images from databases and the web
Excel Application Development   
Loading Excel application configurations from databases
Loading Excel table and pivot table formats from databases
Saving excel table formats to databases
Saving pivot table formats to databases
Translating data table columns within Microsoft Excel to user's language
Customizing context drill-down queries to databases and the web
Customizing context macros and Windows shell commands
Customizing master-detail interfaces
Customizing ribbon Query List, Query Parameters, and Table Views
Customizing Excel formulas including DDE in views and stored procedures
Protecting Excel data and formulas using server handlers
Calling SaveToDB methods from VBA macros
Database Server Support   
Microsoft Azure SQL Database and Microsoft SQL Server
Microsoft SQL Server Compact
Oracle Database
IBM DB2
MySQL and MariaDB
NuoDB
PostgreSQL
SQLite
Licensing   
Commercial usex