Difference between revisions of "Website 3.0 Migration Plan"

From CCCWiki
Jump to: navigation, search
(Go Live)
 
(4 intermediate revisions by the same user not shown)
Line 5: Line 5:
 
In order to refresh the test enviroment, we need to:
 
In order to refresh the test enviroment, we need to:
 
# Copy the test database to backup database so we have backup of the changes we have made to the test environment.
 
# Copy the test database to backup database so we have backup of the changes we have made to the test environment.
# Script changes to tables that been working on.
+
# Copy all files from production environment to the test environment without deleting the current files.
# Restore a copy of the production database to the test database.
+
# Script changes to tables in the production database that have been made.
 
# Apply scripted changes to the test database.
 
# Apply scripted changes to the test database.
# Copy all files from production environment to the test environment without deleting the current files.
 
 
# Apply manual changes to the test enviroment via admin interface.
 
# Apply manual changes to the test enviroment via admin interface.
  
== Manual Steps ==
+
The following tables need be copied:
The following steps will need to be executed manually as part of the migration:
+
* ccc_acy*
* Go to ''Content > Article Manager > Options'' and set ''Linked Titles'' to ''No''
+
* ccc_akeeba*
* Go to ''Extentions > Module Manager > Options'' and set the positions for ''Search'' and ''Smart Search'' to ''head-search''
+
* ccc_contact_details
 +
* ccc_core_log_searches
 +
* ccc_jev*
 +
* ccc_menu*
 +
* ccc_messages*
 +
* ccc_version (does not work)
 +
* ccc_content (only new content)
 +
 
 +
We need to use these settings:
 +
* Data only
 +
* Truncate table
 +
* Maximum lenght: 5000000
  
 +
= Migration Plan =
 
== Up To Two Weeks Before Go Live  ==
 
== Up To Two Weeks Before Go Live  ==
Refresh test database with changes from production as described above.
+
Refresh test database with changes from production as described above every two weeks.
  
 
== Two Weeks Before Go Live ==
 
== Two Weeks Before Go Live ==
 +
Two weeks before go-live, we will institute a freeze on all production environment changes with the exception of the news section so we can test in a stable environment.
  
Two weeks before, go-live we will institute a freeze on all production environment changes with the exception of the news section.
+
== Go Live ==
 +
# Manually apply production changes made in the last two weeks to test environment.
 +
## Add noticesheets and newsletters
 +
# Backup production environment
 +
# Copy database and files from test enviroment to production.
 +
# Perform checkout.
 +
 
 +
== Manual Steps ==
 +
The following steps will need to be executed manually as part of the migration:
 +
* Go to ''Content > Article Manager > Options'' and set ''Linked Titles'' to ''No''
 +
* Go to ''Extentions > Module Manager > Options'' and set the positions for ''Search'' and ''Smart Search'' to ''head-search''

Latest revision as of 21:03, 12 August 2015

Strategy

In order to make sure that we can prepare and test the website in the best way possible, we will refresh the test website from the production website every two weeks. In order for this to be viable we will impose a freeze on every major changes from the start to the project and impose a freeze on production changes from two weeks before launch.

Refresh Process

In order to refresh the test enviroment, we need to:

  1. Copy the test database to backup database so we have backup of the changes we have made to the test environment.
  2. Copy all files from production environment to the test environment without deleting the current files.
  3. Script changes to tables in the production database that have been made.
  4. Apply scripted changes to the test database.
  5. Apply manual changes to the test enviroment via admin interface.

The following tables need be copied:

  • ccc_acy*
  • ccc_akeeba*
  • ccc_contact_details
  • ccc_core_log_searches
  • ccc_jev*
  • ccc_menu*
  • ccc_messages*
  • ccc_version (does not work)
  • ccc_content (only new content)

We need to use these settings:

  • Data only
  • Truncate table
  • Maximum lenght: 5000000

Migration Plan

Up To Two Weeks Before Go Live

Refresh test database with changes from production as described above every two weeks.

Two Weeks Before Go Live

Two weeks before go-live, we will institute a freeze on all production environment changes with the exception of the news section so we can test in a stable environment.

Go Live

  1. Manually apply production changes made in the last two weeks to test environment.
    1. Add noticesheets and newsletters
  2. Backup production environment
  3. Copy database and files from test enviroment to production.
  4. Perform checkout.

Manual Steps

The following steps will need to be executed manually as part of the migration:

  • Go to Content > Article Manager > Options and set Linked Titles to No
  • Go to Extentions > Module Manager > Options and set the positions for Search and Smart Search to head-search