Easy Tracker Database Manager

How to create a new database

How to add a link to existing database

When the database configuration has been changed, please send the configuration file to the person who use Easy Tracker timesheet entry tools. The configuration file Easy Tracker DBConfig.INI usually locates in [Install Dir]Config\. Otherwise, they can not logon the new database or modified database.

Before using this software, please stop any application that will operate on the database, such as Easy Tracker Pro, Easy Tracker Lite, Easy Tracker Reminder, Easy Tracker Report, Easy Tracker Punch Clock, Easy Tracker QuickBooks Integration program.

This function is used for Easy Tracker Professional.

Compresses the selected database. When the size of the database is too big, you can use this function to reduce its size.

Selects the database to compress, clicks Compress button in the tool bar, or selects File, Compress menu, then Database Manager will start to compress the selected database.

Backups the selected database to the specified location. It's a good practice to backup database periodically.

Clicks Backup button , or selects File, Backup menu. In the pop-up dialog, specifies the source file to backup if available, the destination file, then chooses OK to backup.

Restores database from a backup database. The backup database usually locates in Backup in Easy Tracker folder. The restored database will replace the current database file.

Clicks Restore Database button , or selects File, Restore Database menu. In the pop-up dialog, specifies the source file, then chooses OK to restore.

Note: Restores database will delete the selected database, and replaces it with the old backup database.

Attaches an existing Easy Tracker DB file to SQL Server.

When there has an existing Easy Tracker database file detached from SQL server previously, you can use this function to attach this file to the former or new specified SQL server.

Note: the existing database file must be created by Easy Tracker. If you link to an unknown database file, Easy Tracker application, for example Easy Tracker timesheet entry tools or Easy Tracker Pro, may not work normally.

Adds link to an existing database.

When you do know there has a database created by Easy Tracker, then you can use this function to add link to the database. For example, you have installed Easy Tracker suite in a computer, and want to use the database installed in another computer, then you can use Add Link to reference to the remote database.

Note: the existing database must be created by Easy Tracker. If you link to an unknown database, Easy Tracker application, for example Easy Tracker timesheet entry tools or Easy Tracker Pro, may not work normally.

Removes link to the existing database. Just removes the entry from configuration list, the database still exists.

New database

For professional version:

The new database will be created based on the template database. In the dialog, you need specify the destination for the new database file, a template database file, and a database name. After that, clicks OK to create a new database.

For enterprise version:

Please refer to Create a new database(Easy Tracker Enterprise).

Removes the selected database.

Note: Remove Database will delete the selected database permanently.

Refresh

This function is used for Easy Tracker Enterprise.

Changes "SA" password.

1. Click Change Password, Change Password dialog will appear.

2. After enter Current Password, New Password, Confirm Password, and Click OK button.

Note:

1. After modification, all logon with the the same account for the same database server need change password manually.

2. Attention: please remember the new password after modification. If you lose the password, you will have to reinstall MSDE/SQL Server.

When the database configuration has been changed, please send the configuration file to the person who uses Easy Tracker timesheet entry tools. The configuration file Easy Tracker DBConfig.INI usually locates in [Install Dir]Bin\. Otherwise, they can not logon the new database or modified database.

Description

Select or enter a server name

Description

Select or enter a server name