nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Updating database

Senzenberger

I am currently developing a software that needs a connection to the Alfresco database.

In this project it happens very often that the database model has to be changed. With these changes new tables and/or table columns could be added or removed.

At the moment this database model is downloaded in XML format, the existing data is deleted and after updating the database model it is uploaded again.

My question is now: is there a better solution?

Find more posts tagged with

Alfresco Content Services

Comments

abhinavmishra14

First of all it is not recommended to talk to Alfresco DB directly. We should never never be updating/altering anything on db.

Could you please elaborate, what exactly you are trying to achieve ?

By model do you mean content model ?

Senzenberger

Yes you're right I mean the content model.

I am looking for an efficent way (without losing the existing data) to change the content model (data base shema), because I will change this model by adding or deleting tables or column.

abhinavmishra14

Consider using Dynamic model deployment or Model manager as alternatives.

https://docs.alfresco.com/6.0/tasks/deploy-dynamic.html

https://docs.alfresco.com/6.0/concepts/admintools-cmm-intro.html

https://docs.alfresco.com/6.0/concepts/cmm-video-tutorials.html

Senzenberger

Thank you for your commitment

This method is a known-method to me but this method does not fulfill all the requirements that I need.

I achieved the following with the model manager:

1. adding, renaming tables or columns works

2. deleting tables or colums does not works

3. I still lost my data

Please correct me if I'm wrong. Are there any other possibilities to fullfill all my requirements.