Hello,
Recently I have decided to change my cmdbuild schema (classes and domains) as it is too complicated to other users. Could you suggest the most optimal way to transfer data from one cmdbuild database to another?
Thanks in advance
You can export the data of each class in a CSV file, edit it (if the schema is changed) and then reimport it.
Not all changes can be handled in this way, for example you can not export / import via CSV files the N:M relations.
Or you can operate writing some SQL queries to rearrange the whole database.
The second way is much more powerful because it allows you to make faster all the changes that you need, but it is also much more dangerous because SQL-level errors may compromise the integrity of the database and the CMDBuild working way.
CMDBuild Team