Home : Products : OPS SQL : Can you give me the exact instructions for creating a new facility schema within OPSSQL. Thanks
Q10171 - SUPPORT: Can you give me the exact instructions for creating a new facility schema within OPSSQL. Thanks

1.6 Creating New OPS SQL Facilities

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).

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 8/9/2005 10:42 AM.
Last Modified on 8/11/2005 4:17 PM.
Last Modified by No Author Name Available!.
Suggested by Jane St. Pierre
Article has been viewed 3921 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article