Upgrading SaveToDB 7 to SaveToDB 8-10
This document outlines the technical details for upgrading your configured SaveToDB 7 applications to SaveToDB 8-10.
If you're using only the default features of SaveToDB, you can upgrade the add-in without any concerns.
Here are the key differences introduced in SaveToDB 8 compared to previous versions:
- SaveToDB 8 loads definitions for all database objects via the Reload Data and Configuration menu item.
- SaveToDB 8 automatically configures saving changes, event handlers, and parameter value queries.
- SaveToDB 8 features a new default query list, xls.queries.
- SaveToDB 8 introduces a new framework with a different structure.
- SaveToDB 8 applies xls.objects settings to all query lists by default.
SaveToDB 8 represents a significant advancement, as it automatically generates typical configurations by analyzing database metadata and object definitions.
However, the first three features may introduce unwanted changes to applications configured for earlier versions. For instance, a read-only view might become editable, or a foreign key column with ID values could receive a validation list from the primary key table.
While these features are beneficial, you can disable them if necessary.
To disable these features, utilize the new event handler types: DoNotSave and DoNotAddValidation.
Upgrading SaveToDB Framework 7
SaveToDB Framework 8 has been completely redesigned for simplicity and ease of learning.
It now consists of six objects instead of 16, and the object names are consistent across all supported database platforms.
SaveToDB Framework 10 introduces new views for selecting configurations based only on available schemas.
SaveToDB 8-10 supports SaveToDB Frameworks 5-7 and has removed support for Frameworks 1-4.
SaveToDB 7.31 supports SaveToDB Frameworks 8-10.
You can either migrate your applications to a newer framework while staying with SaveToDB 7.31 or upgrade to SaveToDB 8-10 while remaining on SaveToDB Framework 7.
However, we recommend upgrading to SaveToDB 10 and SaveToDB Framework 10 to take full advantage of all features.
Here’s a mapping of Framework objects and roles:
| SaveToDB Framework 5-7 | SaveToDB Framework 8-9 | SaveToDB Framework 10 |
|---|---|---|
| dbo01.QueryList | xls.objects | xls.objects |
| dbo01.EventHandlers | xls.handlers | xls.handlers |
| dbo01.ParameterValues | xls.handlers | xls.handlers |
| dbo01.ObjectTranslation | xls.translations | xls.translations |
| dbo01.ColumnTranslation | xls.translations | xls.translations |
| dbo01.TableFormats | xls.formats | xls.formats |
| xls.workbooks | xls.workbooks | |
| dbo01.viewQueryList | xls.queries (view) | xls.queries (view) |
| xls01.viewQueryList | xls.queries (view) | xls.view_queries |
| xls01.viewEventHandlers | xls.handlers | xls.view_handlers |
| xls01.viewParameterValues | xls.handlers | xls.view_handlers |
| xls01.viewObjectTranslation | xls.translations | xls.view_translations |
| xls01.viewColumnTranslation | xls.translations | xls.view_translations |
| xls01.viewTableFormats | xls.formats | xls.view_formats |
| dbo01.uspUpdateTableFormat | xls.formats | xls.xl_update_table_format |
| SaveToDB_developers | xls_developers | xls_developers |
| SaveToDB_users | xls_users | xls_users |
| xls_formats | xls_formats |
Key differences include:
- SaveToDB Framework 8-10 consolidates to a single xls.handlers table instead of separate dbo01.EventHandlers and dbo01.ParameterValues.
- SaveToDB Framework 8-10 consolidates to a single xls.translations table instead of separate dbo01.ObjectTranslation and dbo01.ColumnTranslation.
- SaveToDB 8 does not include views and procedures except for xls.queries.
- SaveToDB 10 introduces new views and procedures similar to those in SaveToDB Framework 7.
To migrate from SaveToDB Framework 5-7 to SaveToDB Framework 8, follow these steps using the Application Installer wizard:
- Install SaveToDB Framework 8.
- Export current settings to SaveToDB Framework 8 (select SaveToDB Framework 7 and choose Upgrade 7.x to 8.0).
- Remove SaveToDB Framework 7.
To upgrade from SaveToDB Framework 8 to SaveToDB Framework 10, follow these steps using the Application Installer wizard:
- Select SaveToDB Framework 8 and upgrade it to SaveToDB Framework 8x (version 819) or 8.9.
- Select SaveToDB Framework 10 and upgrade to SaveToDB Framework 10.0.