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?
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
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