Installing any database involves significant decisions regarding the size of the database, the maximum number of users, the frequency of automatic backups, and other important issues. Therefore, the following sections provide only suggestions for tuning your database configuration to work with Hexagon PPM software. The ultimate database creation and configuration depends on the policies and standards at your company.
Smart Engineering Manager includes a number of deferrable database constraints, which are rules used to ensure database integrity by checking values at the time the information is written to the database. If all of the information does not fall within these embedded constraints, the information is not written to the database, and the software rolls back the transaction.
These deferrable database constraints are applied only when you use an Oracle database;
SQL Server does not support them.