Installing SaveToDB SDK Samples

The SaveToDB SDK includes the SaveToDB Frameworks and sample projects, complete with source code and test workbooks.

You can download the SaveToDB SDK for your database platform here.

After downloading, unzip the package to a local folder and navigate to the examples directory.

The folder contains files such as:

edit-connections.cmd
setup.cmd
dbsetup.exe.config
samples.xlsx
sample01.zip
sample02.zip
sample07.zip

Installing/Removing Using Wizard

Start by running edit-connections.cmd to update the setup connection string with your database details. Save the changes.

Next, execute setup.cmd and follow the wizard steps.

You can install or remove samples and list existing sample objects in your database.

Each zip file contains a single sample, including source code and installation instructions.

For instance, sample02.zip for Oracle Database includes the following files:

install.lst
list.lst
remove.lst
application-grants.sql
application-install.sql
application-list.sql
application-remove.sql
savetodb-framework-install.sql
savetodb-framework-list.sql
savetodb-framework-remove.sql
label.txt
platform.txt

The package features three operation files: install.lst, list.lst, and remove.lst.

Each file lists the required source code files along with installation instructions.

For example, install.lst might contain:

savetodb-framework-install.sql
application-install.sql
application-grants.sql ?

The first two files are mandatory, while the third is optional.

The installer checks for existing objects and can skip unnecessary files.

Installing/Removing Using Source Codes

You can also use the SQL files from the sample setup package to install or remove samples.

Refer to the required files and their correct order in install.lst and remove.lst.

Changing Connections of Test Workbooks

The workbooks folder contains ready-to-use workbooks designed to help you learn from the samples effectively.

After installing a sample, update the connection strings in the sample workbooks.

You can do this using the Change Connection Wizard in the SaveToDB add-in or the Workbook Connection... wizard in DBEdit.