Single database structure

Versions of Synergetic prior to version 68 use a multiple database structure containing the following databases:

With the introduction of the single database structure in version 68 these databases are included as schemas in a single database as shown below.

Single database example

For general information about:

Database naming requirements and conventions. See Database naming.
Synonyms used to refer pre-68 databases to the new 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.

Last modified: 26/05/2017 2:30:22 PM