Single database structure

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.