@smachua could you look through the Climsoft database for tables that don't currently have primary keys and suggest which fields can make up the primary keys? In many cases these already have unique indices.
We can then create a script with ALTER TABLE table_name ADD primary key (field1, field2, ...) commands as part of the next database update.