To allow for separate databases to be contained in one database, schemas have been utilised.

SQL Server 2005 implemented the concept of a database object schema. A schema is a distinct namespace to facilitate the separation, management, and ownership of database objects. It removed the tight coupling of database objects and owners to improve the security administration of database objects. Database object schemas offer functionality to control and help secure application objects within a database environment not available in previous versions of SQL Server


  • SynergyOne = dbo
  • SynergyOneFinance = finance
  • SynergyOneMedia = media
  • Extra finance DBs = extra finance name

  • Connections will automatically be made to the correct schema
    • Database connections
    • Crystal reports
    • SSRS reports