Engineering Repository Data Base for Honeywell DCS

V

Thread Starter

Vishvesh

Does any one know how the ERDB ( Engineering Repository Data Base ) structure is for Honeywell-Experion system.

Structure as in how exactly data is stored in it and what are different methods to export this data.

Best Regards
Vishvesh
 
Hi

Use Bulk Build/Bulk Edit tools in control builder.

Use xml exports in control builder.

The name of the database in SQL is ps_erdb. You can logon to SQL database with mngr credentials if you have SQL command line interface and you know the queries.

Alternatively, if you have good hands-on SQL then try out extracting data from SQL tables directly.

Go to computer management console -> services & applications -> MS SQL servers-> (local)-> Databases -> ps_erdb. Here you use the micrsoft management console to navigate through various tables, run queries and extract data, analyse the table structures and relationships, triggers etc.

CAUTION:
TAKE ERDB BACKUP BEFORE HAND AND STORE IT SOMEWHERE.
DO NOT COMMIT ANY CHANGE TO THE DATABASE ON AN ONLINE SYSTEM. IT COULD BE SERVERLY FATAL AND LEAD TO A TOTAL COLLAPSE. IT IS AN ONLINE DATABASE.
 
Top