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?
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?
Flag this post as spam/abuse.
Thanks Chandra, that's just what I was hoping for.
I'll give that a go