SQL Scripts OpenEdge

Before you set up EA for use with OpenEdge, we recommend you run the Tools | Data Management | Data Integrity tool on the base project you wish to upsize to OpenEdge. This will ensure data is 'clean' before uploading.

 

Warning: Before proceeding, ensure MDAC 2.6 or 2.7 is installed on your system.

 

 

Upsizing Your Database

There are four stages to upsizing your database for OpenEdge. Follow them in order:

 

Stage One: Install OpenEdge Components

 

1. Install OpenEdge - version 10.0B3 or higher.
 
2. Install OpenEdge ODBC 10.0B or higher driver
 
3. Create a suitable ODBC Data Source to point to your new database.

 

Note: See Setup a Progress OpenEdge ODBC Driver

                       

 

Stage Two: Configure the Database

 

1. Create an empty OpenEdge database, using the scripts OpenEdge_BaseModel.sql file. This is available to registered users on the Corporate Edition resources page of the Sparx website at http://www.sparxsystems.com/registered/reg_ea_corp_ed.html.
 
2. Make sure the new database is selected as the current database.
 
3. Run the script to create all required tables/indexes etc.

 

 

Note: See Create a New OpenEdge Repository

 

 

Stage Three: Transfer the Data

 

1. Open EA (you can press Cancel at the Open Project screen to open with no project loaded).
2. From the Tools | Data Management submenu, select Data Transfer. This will open the Full Model Data Transfer dialog:

 

transferData

 

 

3. Select .EAP to DBMS as the Data Transfer Type.
4. Enter the name of the .EAP file to upsize to OpenEdge as the Source Model.
5. Press the Browse [...] button at the right of the Target Model field. This will open the Datalink Properties dialog.
 
6. Select "Microsoft OLE DB Provider for ODBC Drivers" from the list, then press Next.
       
7. Select the ODBC Data Source you configured to point to your new database.
       

Note: See Connect to a OpenEdge Data Repository for more information.

 

8. Press OK.
 
9. If desired, check the Logfile checkbox and enter a path for the data transfer log file.
                       
10. Press Transfer Data to begin the data transfer process.

 

 

Once the process is completed, you will have upsized your model to OpenEdge and can now open it from EA.