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:
  1. PRODB utility
  2. PROCOPY utility
  3. PROSTRCT CREATE utility
  4. PROREST utility
  5. Data Dictionary
  6. 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 when the source database resides in different directories, the PROCOPY creates target database by using the structure of source database, and places all of the extents in the same directory, unless a .st file already exists for the target database.
  • By using PROCOPY utility, the newly created target database maintains the absolute pathnames convention. 

PROSTRCT CREATE utility:
  • PROSTRCT CREATE utility creates a void database by using a structure description (.st) file. The Database Administrator creates and validates the structure description (.st) file before creating a new database.
  • Newly created database doesn’t contain any meta-schema. Rather, it consists of the database control (DB) area, primary recovery (BI), after-image (AI), application data (.dn), and other areas that defined in the .st file. We must add meta-schema information after creating a void database.
  • We can use the PROCOPY or PRODB utilities for adding meta-schema information to a void database. The OpenEdge RDBMS provides empty databases of each supported database block size.

PROREST utility:
  • PROREST utility creates the database by restoring the backup of source database.
  • PROREST is used when we need to restore the target database from a full source database backup.  
  • PROREST creates one variable-length extent per area for your target database, unless you don’t have structure file at the time of restoring the target database. To have multiple extents in your target database, you must create and apply a structure definition (.st) file.

Data Dictionary:
  • Data Dictionary tool is used to create a new database in a Graphical or Character interface. Data Dictionary tool also maintains the database schema.
  • Using Data Dictionary we can define and update tables, fields, indexes and sequences.

Data Administration:
  • Data Administration tool provides Graphical interface for creating and maintaining OpenEdge database.
  • Using Data Administration we can dump and load data and schema, along with tasks related to reporting, security, and DataServers.



Comments

Post a Comment

Popular posts from this blog

Different Ways to Start/Stop OpenEdge Database

-
Different ways of Starting OpenEdge Database                  OpenEdge database can be Start Up by the four ways: PROSERVE command DBMAN utility OpenEdge Management OpenEdge Explorer    PROSERVE command: §    PROSERVE command starts the  Broker  or  Server   which coordinates all the database requests from all the users to the specified OpenEdge database. §    PROSERVE command starts the main database server i.e.  Broker  which manages all the shared resources and starts the servers as needed for the remote users. §    By default PROSERVE starts the default brokers that can launch both  4GL  and  SQL servers . The 4GL server supports only  remote OpenEdge ABL clients  and SQL server supports only  OpenEdge SQL clients .     DBMAN utility: §   DBMAN utility can only start the database when the da...
Read more

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 : •   ...
Read more

Progress OpenEdge Database Connection Modes

-
We can connect to the OpenEdge Database in Single user mode or Multi user user mode.In single user mode database can be accessed by one user at a time. Multi user mode database can be accessed in different ways and multiple user can access the database at a time or simultaneously. Different Connection Mode:- Single-user Mode Multi-user Mode Batch Mode Interactive Mode Single-user Mode: Running an OpenEdge database in Single-user mode allows only one user to access specified database at a time. Database cannot permit to connect a user form a different Progress session if another user is already accessing the database. Database engine maintain a lock file (.lk) to lock out other users from making connecting to the database Multi-user Mode: Running an OpenEdge database in Multi-user mode allows simultaneous access of the database to more than one user. All the database connection requests are coordinated by the broker, and servers retrieve and store data on beh...
Read more