tags appeared after EA database export+import

[jakson]

I'm trying to move EA database to another MySQL server - that is my main purpose.

EA version: 9.2.921 (Corporate Edition)
MySQL "source" server version: 4.1.11
MySQL "destination" server version: 4.1.22
(our EA doesn't work on MySQL 5.x)

In HeidiSQL (MySQL front-end tool) I export EA database to one large SQL file,
then I replace all "TYPE BTREE" in SQL file to "USING BTREE",
than I import it on "destination" MySQL server (using HeidiSQL).

Everything seems to be OK, but there is something wrong:
- on the bottom of several EA Class-objects appeared "tags" section with 2 tags:
"From ="
"To ="

I didn't use tagged values in my models/elements before exporting it do SQL file.

How to get rid of these tagged values?
- or -
How to export and import EA database properly?

[qwerty]

You should use Tools/Data Management/Project Transfer. Create the scheme on the target side. Then connect to both databases with the above menu and transfer the data.

q.

[jakson]

You should use Tools/Data Management/Project Transfer.

It's not the solution I was looking for -
- I want to create EA database backup (as SQL file) everyday (at about 23:50)
and restore it when necessary (to main/origin database or rather to readonly database with -date/time suffix).

PS
I've found that tags appeared in objects that have BPMN section in properties - when there wasn't BPMN in properties tagged values didn't appear.
Hm... I've never used BPMN or tags - how to get rid of it (automatically)?

[qwerty]

If you ex-/import a database completely you will get an exact copy. So my guess is you are not using the correct procedure for a database backup.

q.

[KP]

I've found that tags appeared in objects that have BPMN section in properties - when there wasn't BPMN in properties tagged values didn't appear.
Hm... I've never used BPMN or tags - how to get rid of it (automatically)?

Tagged values are applied to elements by means of stereotypes. Looking through the BPMN profiles, I see that BPMN 1.0 had a class stereotype "Message" which applied the tagged values "From" and "To". Presumably, when you imported your database, EA found a class with the "Message" stereotype and decided to add its associated tagged values. To prevent this happening, disable the BPMN 1.0 technology and re-import.

[jakson]

Tagged values are applied to elements by means of stereotypes. Looking through the BPMN profiles, I see that BPMN 1.0 had a class stereotype "Message" which applied the tagged values "From" and "To". Presumably, when you imported your database, EA found a class with the "Message" stereotype and decided to add its associated tagged values. To prevent this happening, disable the BPMN 1.0 technology and re-import.

I think this is it:
'From=' and 'To=' tags has appeared only in objects (Classes) with Stereotype = 'Message'

I already managed with that problem in SQL-way:

Code: [Select]

DELETE ea_obp.*
FROM t_objectproperties as ea_obp
WHERE ea_obp.Property IN ('From', 'To');
I know that it is not "pretty" (messing directly on database, omitting EA client), but could it do any damages to EA (objects, diagrams, ... in EA)?
Should I revert my SQL-changes, uncheck BPMN Technology (1.0) and export/import database?
What about BPMN Technology v1.1 and v2.0?

[qwerty]

If you don't need any of the BPMN turn them off. If a MDG is active any of the stereotypes defined therein will create tagged values for elements/connectors with the defined stereotypes.

q.