Posts

Showing posts from March, 2019

Different ways to create OpenEdge Database

We can create the Progress OpenEdge databasae in different ways, it’s totally depend on the situation/requirement the way you follow .  There are six ways of creating an OpenEdge Database: PRODB utility PROCOPY utility PROSTRCT CREATE utility PROREST utility Data Dictionary Data Administration   PRODB utility: PRODB utility creates a database by copying the whole source database to the target database using structure of source database, and places all of the extents in the current working directory. Application developers usually use the PRODB utility to create test or development databases for testing their applications. By using PRODB utility, the newly created target database maintains the same pathname convention, relative or absolute , as the source database.   PROCOPY utility: PROCOPY utility creates a database by copying the meta-schema, schema, & application data from a source database to a target database. Even whe...

Progress OpenEdge Database Architecture

Image
                          OpenEdge Database: •         Database management system is system software for creating and managing databases. •        OpenEdge database is a Relational Database Management System (RDBMS). •        OpenEdge database is a collection of logical storage structures and operating system files that contains permanent data on the disk. •        OpenEdge database is organized into a Logical Database and a Physical Database .   Logical Database: •        Logical database objects described in the database schema and include tables, indexes  and sequences .       Application developers works with logical databases & responsible for creating and maintaining logical database objects . Physical Database : •   ...