Single database structure
- Richard Kennedy (Unlicensed)
Owned by Richard Kennedy (Unlicensed)
Versions of Synergetic prior to Version 68 use a multiple database structure containing the following databases:
- SynergyOne
- SynergyOneFinance
- SynergyOneMedia
- SynergyOneScratch.
From Version 68 onwards these databases are included as schemas in a single database as shown below.
For general information about:
- Database naming requirements and conventions. See Database naming.
- Synonyms used to refer pre-68 databases to the current single database. See Database synonyms.
- Database schemas used to structure database objects within the single database. See Database schemas.
- Collation sequence changes in the single database structure. See Collation sequences.
- Contained databases including the creation of user logins. See Contained databases.
How to
- Update Crystal reports to use the single database structure. See Updating Crystal Reports for the single database structure.
- Update MS Query queries to use the single database structure. See Updating MS Query queries for the single database structure.
- Maintain public finance role security access in the single database structure. See Maintaining public finance role security access in the single database structure.