Ares 4.7 Database Changes

Follow

Several changes were made to the Ares system. Some tables were added, removed, or changed in the Ares database. Additionally, customization keys and tables were added, removed, or changed in the Ares Customization Manager.

Ares now supports TLS 1.2 secure connections

Ares will now support TLS 1.2 secure connections to SQL server. The SQL server that the Ares database is located on must also have support added. Microsoft patches for SQL Server can be obtained online at https://support.microsoft.com/en-us/kb/3135244.

Ares Customization Manager Changes

See Ares Customization Keys for a complete list of the keys and tables available in the Ares Customization Manager.

Added

The following keys and fields were added in Ares 4.7:

  • System | Course & User Loads | CourseUserLoadDataEncrypted
  • System | Course & User Loads | CourseUserLoadKeyPassphrase
  • System | Course & User Loads | CourseUserLoadDataFileCleanup
  • System | Integration | APIConfig Table | ID
  • System | Integration | APIConfig Table | APIKEY
  • System | Integration | APIConfig Table | BaseAPIUrl
  • System | Integration | APIConfig Table | Description

Removed

The following keys and fields were removed in Ares 4.7:

  • Contact Info | Reserves Dept | ReservesContact
  • Contact Info | Reserves Dept | ReservesEmailAddress

Changed

Ares Database

See Ares Database Tables for a complete list of all the tables located in the Ares database.

Added

The following fields and tables were added to the Ares 4.7 database:

Table Name Field Name Change description
  CourseUserLoadDataEncrypted If this key is set to yes, Ares will decrypt the course and user load files. This should only be enabled if you are uploading encrypted files using the public key that Ares created.
  CourseUserLoadKeyPassphrase This key is set automatically when a new key is created for encrypting course and user data loads.

Removed

The following fields and tables were removed from the Ares 4.7 database:

Changed

Table Name Field Name Change description
Items SortOrder Added default value of 0 to fix sorting discrepancy between client and web item listings. When updating to version 4.7, null values in the SortOrder field will be converted to 0.
SharedListItems SortOrder Added default value of 0 to fix sorting discrepancy between client and web item listings. When updating to version 4.7, null values in the SortOrder field will be converted to 0.
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.