Updating database

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Member II

Updating database

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?

3 Replies
Highlighted
Moderator
Moderator

Re: Updating database

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 ? 

~Abhinav
(ACSCE, AWS SAA-C02, GAIQ)
Highlighted
Member II

Re: Updating database

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.

Highlighted
Moderator
Moderator

Re: Updating database