Our organisation is considering implementing SC5 using Oracle 8.1.7 as our DB. I have a concern about the lack of data integrity, even at app level. It seems as though SC is implemented more as a file system instead of a relational type database and over time could result in some serious data inconsistencies and data anomalies normally associated to pre-hierarchical/network database designs.
Questions
- Has anyone experienced data integrity issues relating to SC? For example, contacts belonging to non-existent locations.
- How did you overcome these problems?
- Does SC have any integrity checks and how can they be implemented?
Questions
- Has anyone experienced data integrity issues relating to SC? For example, contacts belonging to non-existent locations.
- How did you overcome these problems?
- Does SC have any integrity checks and how can they be implemented?