Single database structure

Modified on Sun, 19 Apr at 11:55 PM

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

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.

Attachments (2)

System_maintenance_Page_0024_Image_0001.jpg
39.5 KB

69e1f13c6c26b.System_20maintenance_Page_0024_Image_0001.jpeg
39.5 KB