Install Alfresco on another server keeping same DB Schema
We have Alfresco installed and running on one of our application server. Now, we have got a dedicated server for Alfresco. So we want to shift our current Alfresco from the application server to the dedicated server. We also want to use the same DB Schema and content store from the new dedicated Alfresco server instead of current Alfresco server. Need help for performing this process-
1. Is the above mentioned process is feasible?
2. If yes, can someone guide on the step by step process.
3. If we install another Alfresco instance by providing the same DB Schema that we are using now, will that clear up all the existing data and tables?
Re: Install Alfresco on another server keeping same DB Schema
It always depends on how you have setup Alfresco. I have the nagging feeling you might have used the default installer, which typically makes such changes / migration a bit more complicated than they need to be.
To answer your question: Yes, it is feasible. The simplest way would be to just setup Alfresco on the other server, export the schema from the current server and import it on the new one. Also, copy the alf_data/contentstore over to the new server. The approach to exporting / importing depends on the database being used (lookup the appropriate documentation) - if you have used the default Alfresco installer you will be dealing with PostgreSQL which provides the tools pgdump/pgrestore for export/import.
If you setup an Alfresco and point it to an existing database / schema, Alfresco will never override / reset the data structure - that would be extremely unprofessional.