Feedback
Did this article resolve your question/issue?

   

Article

How to create a database with PRODB?

« Go Back

Information

 
TitleHow to create a database with PRODB?
URL Name000036167
Article Number000159304
EnvironmentProduct: Progress
Product: OpenEdge
Version: 9.x , 10.x, 11.x
OS: All supported platforms
Question/Problem Description
How to make a Sports 2000 copy from my OpenEdge installation?
How to create a database with PRODB?
Creating a database with the PRODB utility.
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
PRODB utility creates a new OpenEdge database. The utility copies one whole source database to a new target database. 
Syntax:
prodb <new database name> <original database to make a copy of>

The following examples illustrate how to create databases with PRODB. In order to perform the utility a PROENV section needs to be opened set up and depeding of the Operation System it may vary.

Start the proenv utility by executing proenv script located in the Progress Install Directory/bin:
 
In UNIX, from the shell prompt run $DLC/bin/proenv.

In Windows -
 
Start proenv from the following menu path from your desktop:
Start > Programs > Progress, or OpenEdge > Proenv 

 

To create a new database called myNewDB from a copy of the sports2000 database, enter the following:

prodb myNewDB sports2000

 

To create a copy of the sports2000 database which is named sports2000 enter the following:

prodb sports2000 sports2000


 
To create a new database called pastinfo from a copy of an existing database named currentinfo, enter the following:

 
prodb pastinfo currentinfo


If the target database is not in the current directory or in the DLC qualify the database name with absolute or relative path. For example:
 
prodb directorypath/pastinfo directorypath/currentinfo

 



 
Workaround
Notes
PRODB does not copy the external triggers associated with the database being copied.

References to other documentation:
Progress OpenEdge Data Management: Database Administration, Chapter 1: "Creating and Deleting Databases".
Progress OpenEdge Data Management: Database Essentials, Chapter 3: "OpenEdge RDBMS".
Last Modified Date5/30/2021 6:07 PM
Attachment 
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.