Applying Additional Modules/Schemas to a Database

<< Click to Display Table of Contents >>

Navigation:  Professional > Databases > Admin >

Applying Additional Modules/Schemas to a Database

To apply a custom schema to an already existing database (only needs to be done once per database):


1.Place the schema.<custom_schema_name>.xme file in the db directory of the EQuIS Professional installation, typically C:\Program Files\EarthSoft\EQuIS\db. The sources for EarthSoft program and module Schemas are listed on the Database Schema page.

2.From the same machine, log in to EQuIS Professional and connect to a database server in the Backstage view. If you are already connected to a facility, access the Backstage from the File button on the EQuIS ribbon.

3.On the Connect tab, right-click on a database in the database list on the left.





4.Select Update by clicking from the context menu. The Update Database(s) window opens and lists the databases for which updates are available.

5.Right-click anywhere in the Update Database(s) form and hover the mouse over Module(s). This will display all of the schema update files that are present in the db directory of the EQuIS Professional installation, usually C:\Program Files\EarthSoft\EQuIS\db. The standard EQuIS Professional schemas are listed as "Professional" and "StandardReports".

6.The Update function will only process those schema files with check marks in the corresponding check box, uncheck any schemas that are not desired in the current update process, and make sure that the desired schema is present and checked.

7.Expand the node next to the database record to review the changes that will be made by adding the custom schema.

8.Select the database to be updated (it will be highlighted as in the above screen shot when selected), and then click the Update button.




If the update is not successful, see Update EQuIS Database for more information.


See also Create New EQuIS Database (SQL Server and SQL Server Express) to apply custom schemas to a new database as it is being created.