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.

Open

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.