Once OPSROOT user has been created, OPS Server setup is able to create new OPS SQL facilities. You have 2 ways of creating OPS SQL facilities:
1. Create a new facility
2. Import an OPS32 database
Both of these processes will require you to specify a unique identifier and a facility name for the new facility. The unique identifier is used to create an Oracle user (schema owner) under which all tables, stored procedures, and triggers will be held for the new facility.
Unique Identifier:
This field can only contain letters. No numbers or other special characters. You are limited to a maximum of 8 characters – we recommend you only use 4 characters or less.
Facility Name:
You should use your common facility name. If you call your plant Rocky Creek WWTP – type in Rocky Creek WWTP.
Creating a new facility
1. Run Oracle Server Setup
2. Click on the Create New Facility tab
3. Enter the unique Identifier and the new facility name. Click Execute
Importing an OPS 32 database
1. Run Oracle Server Setup
2. Click on the Import Facility tab
3. Enter the unique Identifier and the new facility name. Click Execute.
When importing, you’ll need to browse for an OPS32 .mdb database file. We recommended that you repair and compact this database file before you import it into OPS SQL. Also, make sure that nobody is logged in the .mdb file when you are importing it (make sure the .ldb file does not exist).