Installing SaveToDB Frameworks

Installing SaveToDB Frameworks

You have three ways to install, update, and remove frameworks:

  1. using the application installer wizard of the SaveToDB add-in,
  2. using the command-line installer from SaveToDB SDK,
  3. using the source codes from the SaveToDB SDK.

The first way is the simplest and the most comfortable if you have the installed SaveToDB add-in.

You can acquire the SaveToDB SDK for your database platform here

https://www.savetodb.com/download.htm

Unzip the downloaded package to a local folder and navigate to the frameworks folder.

The folder contains files like these for Oracle Database:

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

The SaveToDB SDK for SQL Server contains 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 install two additional frameworks:

  • SaveToDB Administrator Framework
  • SaveToDB Developer Framework

The first allows managing permissions using Microsoft Excel.

The second allows generating database objects.

We recommend using both. Install them after the main SaveToDB Framework.

Installing/Removing Using Command-Line Installer

In the first step, run edit-connections.cmd and change the setup connection string to your database. Save it.

Then run the setup.cmd and follow wizard steps.

You can install, update, and remove frameworks or list framework objects existing in a database.

Installing/Removing Using Source Codes

Each zip file in the framework folder contains a single framework, including source codes and installer instructions.

Typically, it contains 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

You can use savetodb-framework-install.sql to install the framework, savetodb-framework-update.sql to update, and savetodb-framework-remove.sql to remove it.