Is the SQL to create the BPMS / BRMS database available?

Solution Unverified - Updated -


I am trying to configure JBoss Enterprise BRMS to use SQL Server as it's DB repository. However, I wish that the database tables/indexes (to be used by JBoss Enterprise BRMS) are created from SQL scripts.

  • Can you please provide me the SQL to create the tables/indexes used by JBoss Enterprise BRMS database? The only work around I can think of is to install JBoss Enterprise BRMS which is already configured with SQL Server, and then export the DDL for the database.
  • Is there further documentation on the database including an E-R design and whether querying the database from outside of JBoss Enterprise BRMS is supported? i.e. Is the design subject to change without notification?


  • JBoss BRMS
    • 5.x
    • 6.x
  • JBoss BPM Suite
    • 6.x
  • Red Hat Decision Central - RHDM
    • 7.x
  • Red Hat Process Automation Manager - RHPAM
    • 7.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.