topic Re: How to create the same schema in Mysql, which is present in H2 db connected with activiti enterprise bpm in Alfresco Archive

How to create the same schema in Mysql, which is present in H2 db connected with activiti enterprise bpm

hiyabasu — Mon, 14 Mar 2016 15:35:06 GMT

Hi All,I have one issue regarding creation of schema in MySql.I am using Activiti bpm enterprise edition for designing my process flow which is now connected to the default H2 database.Now, I want it to get connected to MySQL which I have done by changing the driver, url , username , password in act

Re: How to create the same schema in Mysql, which is present in H2 db connected with activiti enterprise bpm

jbarrez — Tue, 15 Mar 2016 10:44:02 GMT

If you boot up with an empty schema, the Bpm Suite will create all the tables for you. No need to do that.
When running H2, boot up the H2 webapp, go to localhost:8082 and log into db.
From there, execute "SCRIPT simple to 'dump.sql'" to get a sql dump that you can use to insert existing data in the mysql db.

Re: How to create the same schema in Mysql, which is present in H2 db connected with activiti enterprise bpm

hiyabasu — Wed, 16 Mar 2016 10:48:07 GMT

Hi,

Could you please tell me how to execute the "SCRIPT simple to 'dump.sql'" using H2 console.

I want to create a schema in mysql totally similar to that present in h2 db.

I tried running a Sample scripts present in h2 db console but it is just creating a table called Test in H2 db.

Scripts that I executed :

DROP TABLE IF EXISTS TEST;
CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255));
INSERT INTO TEST VALUES(1, 'Hello');
INSERT INTO TEST VALUES(2, 'World');
SELECT * FROM TEST ORDER BY ID;
UPDATE TEST SET NAME='Hi' WHERE ID=1;
DELETE FROM TEST WHERE ID=2;

Can you please help me out. I need that I urgently.

Thanks a lot.

Re: How to create the same schema in Mysql, which is present in H2 db connected with activiti enterprise bpm

jbarrez — Fri, 18 Mar 2016 13:39:16 GMT

"I want to create a schema in mysql totally similar to that present in h2 db."

If it's about the schema, simply configure the BPM Suite to go to an empty schema and it will create all the tables for you.

"Could you please tell me how to execute the "SCRIPT simple to 'dump.sql'" using H2 console."

I assume you're using the default installer of the Activiti BPM Suite? If so, you can log in to it via localhost:8082. Here you can execute that line to get a sql dump that will contain inserts for your data.