Concept

SaveToDB 8 introduces redesigned SaveToDB Framework 8.

It has a more robust structure with fewer configuration objects:

  • xls.objects
  • xls.handlers
  • xls.translations
  • xls.formats
  • xls.workbooks
  • xls.queries

We recommend using SaveToDB Framework 8 for new applications.

SaveToDB 8 has better support for previous versions of SaveToDB Framework in the Application Installer wizard.

So, you may continue to use previous SaveToDB Framework versions as well.

However, you may upgrade SaveToDB Framework 7 to SaveToDB Framework 8 to get new benefits.

Here is a comparison table of SaveToDB Framework objects:

SaveToDB Framework 7SaveToDB Framework 8
Schemas:
dbo01xls
etl01xls
xls01xls
Roles:
SaveToDB_developersxls_developers
SaveToDB_usersxls_users
Tables:
dbo01.QueryListxls.objects
dbo01.EventHandlersxls.handlers
dbo01.ParameterValuesxls.handlers
dbo01.ColumnTranslationxls.translations
dbo01.ObjectTranslationxls.translations
dbo01.TableFormatsxls.formats
Views:
dbo01.viewQueryListxls.queries
xls01.viewQueryListxls.queries
xls01.viewEventHandlersxls.handlers
xls01.viewParameterValuesxls.handlers
xls01.viewColumnTranslationxls.translations
xls01.viewObjectTranslationxls.translations
xls01.viewTableFormatsxls.formats
xls01.viewObjectDescriptionremoved
Procedures:
dbo01.uspUpdateTableFormatxls.formats
etl01.uspUpdateColumnTranslationremoved
etl01.uspUpdateColumnTranslation_Groupremoved
etl01.uspUpdateObjectTranslationremoved
etl01.uspUpdateObjectTranslationAbsentremoved

Upgrade Steps

Upgrade steps include:

  1. Upgrading the SaveToDB add-in to the latest version SaveToDB 8.7 on users' computers
  2. Installing SaveToDB Framework 8
  3. Exporting SaveToDB Framework 7 settings to SaveToDB Framework 8
  4. Removing SaveToDB Framework 7
  5. Changing framework objects in the application configuration objects

Installing SaveToDB Framework 8

Run Wizards, Application Installer, connect to your database and select SaveToDB Framework 8.

You may check that the framework is not installed and select the Install operation:

Install SaveToDB Framework 8

In this step, check that you have SaveToDB Framework 8.7 and click Execute:

Execute the SaveToDB Framework 8 installation code

You will see the installation results. Click Back.

Check SaveToDB Framework 8 installation results

Now you may see that the SaveToDB Framework 8 is installed:

Check SaveToDB Framework 8 objects

Exporting SaveToDB Framework 7 to SaveToDB Framework 8

Select SaveToDB Framework 7 and the Upgrade 7 to 8.0 operation. Click Next.

Export SaveToDB Framework 7 to SaveToDB Framework 8

This page contains the upgrade SQL code. Click Execute.

Execute the SaveToDB Framework 7 to SaveToDB Framework 8 export code

You will see the upgrade results.

Check SaveToDB Framework 7 to SaveToDB Framework 8 export results

You may check imported settings the SaveToDB Framework 8 tables (xls.objects, xls.handlers, etc.).

Please note that migrating roles works in Microsoft SQL Server only.

For other database platforms, add roles and users to the xls_developers and xls_users roles manually.

Removing SaveToDB Framework 7

You may remove SaveToDB Framework 7 after the next step if you have a lot of application configuration objects.

Also, we recommend saving the configuration workbook with SaveToDB Framework 7 settings (Wizards, Application Workbooks).

Select SaveToDB Framework 7 and the Remove operation. Click Next.

Remove SaveToDB Framework 7

Cross fingers and click Execute.

Execute the SaveToDB Framework 7 remove code

You will see uninstalling results:

Check SaveToDB Framework 7 remove results

The uninstaller removes users from roles in Microsoft SQL Server only.

Changing Application Objects to SaveToDB Framework 8

Your database applications may contain application configuration objects that extend SaveToDB Framework objects.

The most used are query list views.

You may use Search and Replace to change the framework objects used in the FROM clause:

SaveToDB Framework 7SaveToDB Framework 8
Tables:
dbo01.QueryListxls.queries
dbo01.EventHandlersxls.handlers
dbo01.ParameterValuesxls.handlers
dbo01.ColumnTranslationxls.translations
dbo01.ObjectTranslationxls.translations
dbo01.TableFormatsxls.formats
Views:
dbo01.viewQueryListxls.queries
xls01.viewQueryListxls.queries
xls01.viewEventHandlersxls.handlers
xls01.viewParameterValuesxls.handlers
xls01.viewColumnTranslationxls.translations
xls01.viewObjectTranslationxls.translations
xls01.viewTableFormatsxls.formats

The objects have the same column names except for the ParameterValues and handlers tables.

Also, add the COLUMN_NAME IS NULL into JOIN statements for queries from the ObjectTranslation tables and views as the new xls.tanslations table contains translations for objects and columns.

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.OK