Database Management / Rollbase/ OE DB / PrivateCloud - Forum - Rollbase - Progress Community

Database Management / Rollbase/ OE DB / PrivateCloud

 Forum

Database Management / Rollbase/ OE DB / PrivateCloud

This question is answered

How do we do db-management with oe-db? is there anye GUI? I need something like SQL Management Console.

Or should I use MS SQL-Server?

Does anyone have an opinion about the adv/disadv between MS SQL DB and OE DB?

Verified Answer
  • We have a command line application to manage the OE DB. It is shipped with Rollbase private cloud installer. Follow the below steps to get the command line option

    1) Start the proenv.bat (Available at C:\Progress\Rollbase\db\bin\proenv.bat)

    2) Execute the following command

        set jrehome=%DLC%/jre

    3) Execute the following command to connect a database

        sqlexp -db rbdb -S 8911 -user dbadmin -password dbadmin

    4) Execute the SQL command.

    Refer the below screenshot.

    GUI based tool is available with Enterprise edition of OpenEdge Database

All Replies
  • We have a command line application to manage the OE DB. It is shipped with Rollbase private cloud installer. Follow the below steps to get the command line option

    1) Start the proenv.bat (Available at C:\Progress\Rollbase\db\bin\proenv.bat)

    2) Execute the following command

        set jrehome=%DLC%/jre

    3) Execute the following command to connect a database

        sqlexp -db rbdb -S 8911 -user dbadmin -password dbadmin

    4) Execute the SQL command.

    Refer the below screenshot.

    GUI based tool is available with Enterprise edition of OpenEdge Database