Introduction

CADMATIC eShare stores data in Microsoft SQL Server databases. The database architecture of eShare is such that there is one main database for running the server, and then one database for each plant or marine design project. This distributed structure makes it very efficient to access a given database and search and join data, and it allows a database administrator to easily back up and remove specific projects.

Before eShare is installed on a site, it needs to be decided whether the database login that eShare uses is to have permissions that allow it to create, upgrade, and remove databases, or whether its permissions only allow it to update data in existing databases.

We recommend eShare to use a database login that does not have administrative privileges, but this does require a more active role from the eShare database administrator. For the most part, this document describes tasks that a database administrator needs to perform if eShare is working with minimal database permissions.

If, however, your site wants to deploy eShare in the simplest possible way and provide eShare with a database login that minimizes human administrative work, we recommend that you review the information in Database configuration, but basically all you need to install the system is a database login that has administrative privileges.

For information on supported versions and editions of Microsoft SQL Server, see docs.cadmatic.com/systemrequirements.