Database

AVEVA Work Tasks uses the following two databases:

• Farm Database in which Farm Configuration settings are stored.

• Repository Database with tables pertaining to each repository.

  Notes:
  - It is recommended to maintain separate databases for Farm and Repository (datasource).
  
  - The recommended collation for the databases is:
  SQL_Latin1_General_CP1_CI_AS
  
  - The Farm and Repository databases support case sensitive collation:
  SQL_Latin1_General_CP1_CS_AS