Creating a Training Database

When using a Training database, this allows the user to train employees on an active database without affecting the live data. When enabled, a Training mode message will be displayed in the upper right-hand corner of the main Sunlync window, showing that the user is currently on the training database.

The user will not be able to connect to a training database with a live client, and the user will not be able to connect to a live database with a training client.

In order to use this function, the user must be running Sunlync Select v 4.0 or later. The following instructions will allow you to configure this option.

Create a copy of your live data

For instructions on doing so, please refer to the Sunlync Technical Guide. From here go to the bottom of page 10 and look for the following heading.

How to Back Up MySQL

The new database should have a different name than the live Sunlync database. For example, if the live database is sunlync, the training database's name could be sunlync_training.

Update the version number of the database

In order for a new database to be treated as a training database, the database_version field needs to be updated. Use the folllowing query in MySQL to do so:

Update parmfile set database_version='X.X.X.X-T';

Replace X.X.X.X with Sunlync's version number that the user has installed (example 7.0.5.9).

Change Data Sources to use new database

1. Click Start, then click all programs.
2. Click Sunlync, then click on Set up MySQL connection.
3. Change the database name to the name of the training database (Typically Pilot)
4. Click Save and Exit

Modify the Sunlync Shortcut

Once the training database has been created, the Sunlync shortcut needs to be modified. Use the following steps to do so.

1. Right-Click the existing Sunlync shortcut and select copy
2. Right-Click the Windows Desktop and select paste
3. Right-Click the new shortcut and select Properties.
4. In the Target: field , insert the word TRAINING after the command listed 
5. Click OK to save the changes

The user would also want to rename the shortcut to avoid confusion.  Once the shortcut has been created click on the training shortcut to access the training database.