Installing SaveToDB Frameworks

You have three options for installing, updating, and removing frameworks:

1. Use the application installer wizard of the SaveToDB add-in.
2. Use the command-line installer from the SaveToDB SDK.
3. Use the source code from the SaveToDB SDK.

The first option is the simplest and most user-friendly if you already have the SaveToDB add-in installed.

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

https://www.savetodb.com/download

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

Framework Files

The frameworks folder contains different files depending on your database platform. For Oracle Database, you’ll find:

edit-connections.cmd
setup.cmd
dbsetup.exe.config
savetodb-framework-7-for-oracle.zip
savetodb-framework-8-for-oracle.zip
savetodb-framework-9-for-oracle.zip
savetodb-framework-10-for-oracle.zip

For SQL Server, the folder includes more files:

edit-connections.cmd
setup.cmd
dbsetup.exe.config
savetodb-administrator-framework-10-for-sql-server.zip
savetodb-developer-framework-10-for-sql-server.zip
savetodb-framework-7-for-sql-server.zip
savetodb-framework-7-for-sql-server-(mysql-style).zip
savetodb-framework-7-for-sql-server-(oracle-style).zip
savetodb-framework-7-for-sql-server-2000.zip
savetodb-framework-8-for-sql-datawarehouse.zip
savetodb-framework-8-for-sql-server.zip
savetodb-framework-9-for-sql-datawarehouse.zip
savetodb-framework-9-for-sql-server.zip
savetodb-framework-10-for-sql-datawarehouse.zip
savetodb-framework-10-for-sql-server.zip

For SQL Server, you can also install two additional frameworks:

• SaveToDB Administrator Framework: Manages permissions using Microsoft Excel.
• SaveToDB Developer Framework: Generates database objects.

We recommend installing both after the main SaveToDB Framework.

Installing/Removing Using Command-Line Installer

First, run edit-connections.cmd and update the setup connection string to match your database. Save the changes.

Next, execute setup.cmd and follow the wizard steps. You can use this method to install, update, or remove frameworks, or to list existing framework objects in your database.

Installing/Removing Using Source Codes

Each zip file in the frameworks folder contains a single framework, along with source code and installation instructions. Typically, it includes the following files:

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

To manage the framework, use the following SQL scripts:

• savetodb-framework-install.sql to install the framework.
• savetodb-framework-update.sql to update it.
• savetodb-framework-remove.sql to remove it.