We have a large Rollbase application.
Our Rollbase database is MySQL, not OpenEdge.
The MySQL database is in AWS.
The challenge is that the underlying Rollbase schema is very different than the schema you see inside the Rollbase GUI.
When we log into Rollbase backend.
We see tables like "Donation", "Program", and "Employee".
Under the hood, however, Rollbase stores every record regardless of table inside a single MySQL table called "RB_OBJ_DATA".
We need to create a MS SQL server database schema of the RB_OBJ_DATA and migrate the data over to the new database schema.
What is the best approach to do this?
We want to create an automotive approach so we can run the process many times over and still have accurate results with data migrating from RB_OBJ_DATA MySql to MS SQL.
You will work daily with one of our developers to access our Progress (Rollbase), AWS and setup Azure database.
You will not have free rein to access these...