Show TOC

Function documentationUnderstanding the DBTools Main Window

 

When the DBTools application successfully connects to the database it changes the title of the application window. When the application first started the window title was Triversity Database Tools, but after connection has been established you will see database information as part of the window title.

The functions that are most frequently used are set up as buttons on the button bar but as all functions, can be accessed from the Tools menu.

File

New Data Scource

Selecting the menu option will display the database login window to allow you to connect to a different database.

Exit

Exits the DBTools application

Tools

Backup

Allows you to backup the database the application is currently connected to. Some functions within the DBTools application require that the database be backup up and will not allow you to continue until the database is, in fact, backed up.

Restore

Allows you to restore a previously backed up database.

Export Data

Allows you to export data from any table within the database to a file. There are several file formats to choose from including text, and Excel.

Import Data

Allows you to import data from a file to any table within the database. This is limited to tab delimited or comma delimited text files with no headings.

View Data

Allows you to view the data in the database. The data that is selected to view can be based on search criteria you enter.

Move Database

Allows you to move the database file location. The database file cannot be moved using MS Explorer or other similar means. All Transactionware applications need to be aware of the location of the database. The DBTools application knows how to move the database and how to make all other Transactionware applications aware of the move.

Upgrade Database

Allows you to upgrade the database from one application version to the next. Applying scrpt files supplied by SAP completes the upgrade.

Database Sizing

Allows you to see how and where the database will grow based on criteria you enter.

New Store Reset

Prepare the database for the opening of a new store.

Purge Database

Allows you to selectively delete the data from table(s).

Table Information

Allows the user to get information about the tables within a database.

Window

All items under the Window menu are standard Windows items.