Training Database Setup

Training Database Setup

Purpose

To create a dedicated Training Database where users can safely explore system features and practice processes without affecting live production data.

Setup

  1. Create a Ledger Data folder structure for the Training ledger under the ArgosData folder.
  2. Obtain Database Backup to use as the training database.
  3. Create new Database on SQL Server.
  4. Restore backup into new Database.
  5. Assign access to the database for the Argos Users SQL Login as db_owner & public.
  6. Create a system ODBC DSN Connection for the training database on all machines which will access the training database.  The DSN name must end with the text  “_TRAINING” (case sensitive).
  7. This will cause the main screen of Argos Vault to reset the colour to red and will prompt the user, with a warning when they log in, that the system is in training mode.  They will be advised to take care as processes may impact on live data as file paths may still point to live files.
  8. Create a shortcut to Argos Vault on each machine used to access the training database and set the connection details (including the DSN setup in step 6) in the shortcut parameters.
  9. Test to ensure connection to the correct database.
  10. Reset the file path locations.
    • Related Articles

    • Setup the database

      Database Setup Create New Database In Server Management studio: 1. Right click on the folder ‘Databases’ and select ‘New Database’. The below dialog will be displayed: 2. Enter the Database name - (Usually the name of your finance company or an ...
    • Backup Database

      Purpose To create a regular Backup of your database. Normally a Backup will be created daily. Pre and Post month end Backups are recommended also. It is also recommended that a Backup be taken before a significant set up change or running a process. ...
    • Internal API Setup

      Purpose Allows configuration for the Internal API used to power Vault. Access Control | Internal API Setup Dialog Details Detail Specific Fields Field Description Internal API URL Enter the complete URL for the Internal API. You can press the "Use ...
    • Database Schema Changes

      154-155 4905: Created table AccTrnCashbookStatementAssociation 4910: Added PresetEx.LegacyPresetNum column 4915: Created table GenJnlCorrection 4930: Added columns PrincipalAccruedInterestGeneralLedgerCodeId and ...
    • Account Letter Details (Setup)

      Purpose Set up the sequence of Overdue Letters for each lending module. There will be a separate sequence for each lending module. There can be more than one sequence for any lending module. The sequence will determine the rules to be used by the ...