Is the SQL to create the BRMS / BPM Suite database available?

Solution Verified - Updated -

Issue

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?

Environment

  • Red Hat JBoss BRMS
    • 5.x
    • 6.x
  • Red Hat JBoss BPM Suite
    • 6.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
Close

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