topic Promoting Alfresco from development to test environment in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/promoting-alfresco-from-development-to-test-environment/m-p/256805#M209935 <HTML><HEAD></HEAD><BODY><SPAN>We have a standard application staging environment where we have our Alfresco application running on a development server, a testing server and a production server. </SPAN><BR /><BR /><SPAN>Once development of an iteration is complete we tag our source code and run a build process to move it to the testing server. Once the testers have successfully completed testing the application will be deployed to the production server.</SPAN><BR /><BR /><SPAN>Moving the modified source code between staging environment is straightforward. However, many of the changes that need to be migrated between environments are contained within the database. Currently, we manage this by (e.g. from development to test):</SPAN><BR /><BR /><SPAN>1) Using a script to dump the database table structure from the development database into an SQL script</SPAN><BR /><SPAN>2) Running the SQL script in the testing database to drop and recreate all the tables with the new data</SPAN><BR /><BR /><SPAN>Can anyone suggest a better way to manage this process?</SPAN></BODY></HTML> Tue, 31 Jan 2012 09:42:15 GMT pcharsle 2012-01-31T09:42:15Z Promoting Alfresco from development to test environment https://connect.hyland.com/t5/alfresco-archive/promoting-alfresco-from-development-to-test-environment/m-p/256805#M209935 We have a standard application staging environment where we have our Alfresco application running on a development server, a testing server and a production server. Once development of an iteration is complete we tag our source code and run a build process to move it to the testing server. Once the Tue, 31 Jan 2012 09:42:15 GMT https://connect.hyland.com/t5/alfresco-archive/promoting-alfresco-from-development-to-test-environment/m-p/256805#M209935 pcharsle 2012-01-31T09:42:15Z Re: Promoting Alfresco from development to test environment https://connect.hyland.com/t5/alfresco-archive/promoting-alfresco-from-development-to-test-environment/m-p/256806#M209936 <HTML><HEAD></HEAD><BODY><SPAN>Are you dumping the database and loading it because you are moving content within the repository between environments? If so, note that you also need to be moving the alfresco data directory (content store).</SPAN><BR /><BR /><SPAN>If that is what you are trying to do, depending on how much content you are moving between environments, you may want to look at using Alfresco Content Packages (ACPs). ACPs can be exported and imported between environments of the same Alfresco version without a problem.</SPAN><BR /><BR /><SPAN>Here's the wiki page on ACPs: </SPAN><A href="http://wiki.alfresco.com/wiki/Export_and_Import" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Export_and_Import</A><BR /><BR /><SPAN>Hope that helps,</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Tue, 31 Jan 2012 20:03:49 GMT https://connect.hyland.com/t5/alfresco-archive/promoting-alfresco-from-development-to-test-environment/m-p/256806#M209936 jpotts 2012-01-31T20:03:49Z