Database schemas

Database schemas

Schemas are distinct containers used to separate and manage database objects in the single database structure.

There are four schemas in the single database that are used to replace the functionality of the databases used with pre-68 versions of Synergetic.

Schema examples

Previous database name	New schema name
SynergyOne	dbo
SynergyOneFinance	finance
SynergyOneMedia	media
SynergyExtraFinance	extrafinance

For more information about database schemas, see Microsoft database schemas.

Last modified: 26/05/2017 1:33:16 PM

See Also

Single database structure

Database naming

Database synonyms

Collation Sequences

Contained databases

Updating Crystal Reports for the single database structure

Updating MS Query queries for the single database structure

Maintaining public finance role security access in the single database structure

© 2017 Synergetic Management Systems. Published 20 July 2017.