Copy DB and schema - OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

What new features or enhancements could improve the OpenEdge Database? Use this challenge to let the OpenEdge team know what would make your life easier by reducing costs and increasing productivity!

Copy DB and schema

No idea if this is something that others would want, but currently I need to copy a database and its schema and it would be a lot easier if I could do this with a simple procopy style command. 

  • Hi James

    Reading this, I interpret that you would like an empty copy of the database / schema.

    What I have done when needing this is

    - on a restored db, script a truncate of all areas and a remove of all extents except the last one.

    Then you have a small empty db.

    ProBackup / restore to move it.


  • Yes but that's a lot of work just to copy the schema. I might as well just copy the .st, and apply the .df.