Table name update

Hi,

I am trying to update the existing H2 DB table name but not able to do .Already migrated H2 db to ms-sql db.

My Current table name is like : dbo.ACT_(table name)
My requirement is : dbo.COGNI_(table name).

My process.xml is here:

<?xml version="1.0" encoding="UTF-8" ?>

<process-application
    xmlns="http://www.camunda.org/schema/1.0/ProcessApplication"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <process-archive name="IDCS-Generation">
   <process-engine>default</process-engine>
    <resource>vimeo.bpmn</resource>
   

    <properties>
    
     <property name="databaseTablePrefix">COGNI_</property>
      <property name="databaseSchemaUpdate">true</property>
      <property name="isDeleteUponUndeploy">false</property>
      <property name="isScanForProcessDefinitions">true</property>
      
      
     
    </properties>
    
    
  </process-archive>

</process-application>

Jauhari

Hi @jauhari,

What is your actual goal? Do you want to change for example ACT_RU_EXECUTION to COGNI_RU_EXECUTION or to COGNI_ACT_RU_EXECUTION?

Cheers,
Roman

Hi @roman.smirnov,
my goal is COGNI_RU_EXECUTION

Jauhari

Hi @jauhari,

This is not possible.

Cheers,
Roman

1 Like

so ``` COGNI_ACT_RU_EXECUTION?`` is possible? How?

Jauhari

Hi @jauhari,

You have to set the property databaseTablePrefix to COGNI_ as you already did in your process.xml. Furthermore, you have to change the value of dataSchemaUpdate to false, then you have to create the database schema and tables by your own. Therefor you have to manually adjust the create scripts accordingly so that the tables are created with the prefix COGNI_.

In case of tomcat you can find some documentation on how to manually create the database schema and tables in 1.

Cheers,
Roman