I try to update my local machine with Rollbase from version 3.1.3 to 4.0 for some testing.
i followed these steps:
Everything is going well until I get to step 9
How can i update the OE database with the SQL scripts downloaded at step 1 (update_3_2_0.sql and update_4_0_0.sql).
Thanks in advance.
You should comment out the default one's & uncomment the lines following 'OpenEdge' by removing the leading double dashes at all places throughout the file. This will help you run the file against OE database. So, do this for both 3.2 and 4.0 scripts and run them in that same order.
That's what I saw in the documentation, my question is actually how to run the SQL script against the database? witch program should i have to use?
Hi Jorrit -
Please find the solution in a similar thread community.progress.com/.../70245.aspx
The link is not working.
Group Not Found
The requested Group cannot be found.
RB Installer By default update_4_0_0.sq file not run on existing database. We manually run update script on OE Database.
Please follow the below steps to run update script.
Swtich to <Rollbase Home>\Rollbase\db\bin\proenv.bat. After that
2.sqlexp -db rbdb -S 8911 -user dbadmin -password dbadmin -infile update_4_0_0.sql
By Default update_4_0_0.sql file has Update against MYSQL database . Need to uncomment lines related to OE database and comment existing one.
After run update_4_0_0.sql restart Serv
- See more at: community.progress.com/.../70245.aspx
Thank you ill try it later this day and let you know what the result is.
When I updated to 4.0 the service appeared to execute update_4_0_0.sql script upon startup.
I had tested this by
I wanted to do this as this was my first update and I wanted to see what happened when i skipped steps
Is it a valid conclusion that the script does indeed run?
Yes. You can also look for tables/columns in the schema that corresponds to entries in update_4_0_0.sql