Forum Post: Is there an easy way to replicate a Progress DB schema into an HSQLDB database

  • Thread starter Thread starter andrew.may
  • Start date Start date
Status
Not open for further replies.
A

andrew.may

Guest
We have Java components that access our Progress DBs via SQL. To do automated integration testing of our Java components, I would like to be able to create a (very fast) in-memory HSQLDB which had an identical SQL schema to our Progress DB & then load static test data into it. I could then connect our Java components to the test DB & run test suites very quickly. As our Progress schema changes (& is committed to source control), I would want to be able to automate the production of the HSQLDB. To do this, I would need a way to automatically generate (from the Progress DB) the SQL commands needed to create the HSQLDB. i.e. all these statements... CREATE TABLE FOO (ID NUMERIC PRIMARY KEY, BAR VARCHAR(255)); ... etc ... Is there any Progress functionality that I could use to do this?

Continue reading...
 
Status
Not open for further replies.
Back
Top