New article
Recently updated
Setting-up a Training Database
The steps below outline how to setup the training database using your live database, as well as additional considerations:
1. Backup your existing live database.
2. Restore this as QPulse5Training.
3. On the application server, go to C:\Program Files\Gael Ltd\Q-Pulse 5 Server.
4. Locate your DBConnections.xml file and open this with Notepad.
5. The highlighted section below shows the connection information for your default database - copy this section from your DBConnections.xml file.
6. Paste the copied connection string before the closing of the ConnectionList tag.
7. Update the copied Connection string to point to the Training database previously restored in step 2 and also to have a different display name as shown below:
8. Save this file.
9. Create the Licence allocation by launching ServerConfigUtil.exe which can be found in your Ideagen Quality Management 5 Server installation directory, On the application server, go to C:\Program Files\Gael Ltd\Q-Pulse 5 Server , or for 64 Bit Systems C:\Program Files (x86)\Gael Ltd\Q-Pulse 5 Server.
10. Import your database connections (DBconnections.xml). You can set options to specify a licence allocation for each database or allow all databases to share a single pool of licences.
11. Click OK to complete the process.
12. Re-start the QPulse5 Server service.
Handling Linked Documents
If your documents are linked then if you make a change in the training database (e.g. make a new revision or delete a document) it will perform the same action as if you where in the live database.
Handling Linked Documents
If your documents are linked then if you make a change in the training database (e.g. make a new revision or delete a document) it will perform the same action as if you where in the live database.
After you have restored the training database run the below script using Microsoft SQL Management Studio. This will remove the link to the documents and prevent any accidental amendments or deletions of documents.
USE QPulse5Training
UPDATE RevisionAttachmentItem
SET AbsolutePath = NULL
go
UPDATE RevisionChangeAttachmentItem
SET AbsolutePath = NULL
go
Connecting the Audit Log to The Training Database
When setting up a training database and you have the audit log active on your license you will have to ensure that you training database is connected to a valid audit log.
To set up the training database audit log you will need to have a blank audit log database. To download this click (here)
Once you have installed this you will need to create this within SSMS and set this up as QPulseAuditLogTraining.
Go to "Object Explorer" and then right-click on Databases
1. Select Tasks, then New Database
2. In the "New Database" screen, make sure the To Database field has the entry "QPulseAuditLogTraining"
3. Select the From Device option, then in the next window, click the ADD button
4. Locate and highlight the database you have downloaded and then click the OK button
5. The database you selected will then appear below the "Select the backup sets to restore" section
6. Tick the Restore box, then click Options at the top left of this screen
7. Click OK
8. Once the database has been restored, right-click on the database and select [New Query]
9. Enter the following command:
exec sp_change_users_login 'auto_fix','qpulseauditloguser'
10. Click Execute
This is now your QPulseAuditLogTraining database set up and you can now connect your QpulseTraining Database to this.
The next step is now to connect your Tracebilityconnectioninfo from your database to the audit log. This is done by running an SQL query against the QPulsetraining Database. See Script below.
update accounttemplate
set traceabilityconnectioninfo=N'<?xml version="1.0" encoding="utf-8" ?>
<ConnectionList>
<Connection>
<DisplayName>LocalTest</DisplayName>
<ConnectionString>data source=SERVERIP\INSTANCE;initial catalog=QPulseAuditLogTraining;persist security info=False;user id=QPulseAuditLogUser;packet size=4096;password=PASSWORD;Pooling=false;Connect Timeout=1200</ConnectionString>
<Provider>BacchusSql</Provider>
<DbType>Sql</DbType>
<AllowWindowsAuthentication>False</AllowWindowsAuthentication>
</Connection>
</ConnectionList>'
- Replace SERVERIP\INSTANCE with the IP address and the instance name of your SQL server
- Replace PASSWORD with the password set for your QPulseAuditLogUser
Notice that the catalog has already been changed to say QPulseAuditLogTraining for you, however, if this is not what you have called this please update the catalog.
Additional Considerations
To prevent any unexpected issues when using the training database, below are some points you may wish to consider:
- If enabled, emails will be sent when performing actions. You may want to either change the email addresses or disable the email options within the Administration module.
- The Live database and the Training database will look identical. It is recommended to change the module titles to make it clear that the user is in the training database. This will prevent any confusion.
- If you use the Ideagen Quality Management Web client in v6.5 and above. When adding a new Training Database, the New Ideagen Quality Management Web Client makes use of sub-domains to make sure that your databases are properly isolated from each other. DNS Configuration Required for the New Ideagen Quality Management Client – Ideagen Quality Management (ideagen.com) - without following the configuration guide for a new training database, you will not be able to access the Ideagen Quality Management Web Client.