topic Re: Migrate from Postgresql to Oracle post installation of Alfresco Enterprise Edition in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/migrate-from-postgresql-to-oracle-post-installation-of-alfresco/m-p/293449#M246579 <HTML><HEAD></HEAD><BODY><A href="http://docs.alfresco.com/4.2/topic/com.alfresco.enterprise.doc/tasks/oracledb-config.html" rel="nofollow noopener noreferrer">http://docs.alfresco.com/4.2/topic/com.alfresco.enterprise.doc/tasks/oracledb-config.html</A><BR /><BR /><SPAN>Assuming that you are not actually doing a migration of data you should just be able to change the database property in alfresco-global.properties.&nbsp; Add the oracle driver. Drop any alfresco full text indexes.&nbsp;&nbsp; And restart.&nbsp;&nbsp;&nbsp; </SPAN><BR /><BR /><SPAN>You may also like to remove the stopping and starting of postgressql with alfresco which probably requires some code to be commented out of the startup script, but that can wait until later.</SPAN></BODY></HTML> Wed, 22 Jan 2014 11:08:41 GMT mrogers 2014-01-22T11:08:41Z Migrate from Postgresql to Oracle post installation of Alfresco Enterprise Edition https://connect.hyland.com/t5/alfresco-archive/migrate-from-postgresql-to-oracle-post-installation-of-alfresco/m-p/293448#M246578 I have installed the Alfresco Enterprise Edition using the the Easy Setup Wizard which installed it with PostgreSQL. I would like to use Oracle as we have client requirement to use Oracle as DB. I have installed oracle server on the other machine, created the database, user for alfresco.I need to ch Wed, 22 Jan 2014 09:13:16 GMT https://connect.hyland.com/t5/alfresco-archive/migrate-from-postgresql-to-oracle-post-installation-of-alfresco/m-p/293448#M246578 gbarala 2014-01-22T09:13:16Z Re: Migrate from Postgresql to Oracle post installation of Alfresco Enterprise Edition https://connect.hyland.com/t5/alfresco-archive/migrate-from-postgresql-to-oracle-post-installation-of-alfresco/m-p/293449#M246579 <HTML><HEAD></HEAD><BODY><A href="http://docs.alfresco.com/4.2/topic/com.alfresco.enterprise.doc/tasks/oracledb-config.html" rel="nofollow noopener noreferrer">http://docs.alfresco.com/4.2/topic/com.alfresco.enterprise.doc/tasks/oracledb-config.html</A><BR /><BR /><SPAN>Assuming that you are not actually doing a migration of data you should just be able to change the database property in alfresco-global.properties.&nbsp; Add the oracle driver. Drop any alfresco full text indexes.&nbsp;&nbsp; And restart.&nbsp;&nbsp;&nbsp; </SPAN><BR /><BR /><SPAN>You may also like to remove the stopping and starting of postgressql with alfresco which probably requires some code to be commented out of the startup script, but that can wait until later.</SPAN></BODY></HTML> Wed, 22 Jan 2014 11:08:41 GMT https://connect.hyland.com/t5/alfresco-archive/migrate-from-postgresql-to-oracle-post-installation-of-alfresco/m-p/293449#M246579 mrogers 2014-01-22T11:08:41Z