You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@continuum.apache.org by ws...@apache.org on 2009/01/17 02:11:57 UTC

svn commit: r735194 - in /continuum/trunk/continuum-docs: ./ src/site/apt/installation/upgrade.apt

Author: wsmoak
Date: Fri Jan 16 17:11:57 2009
New Revision: 735194

URL: http://svn.apache.org/viewvc?rev=735194&view=rev
Log:
[CONTINUUM-2013] Update documentation on upgrading from 1.2.x to 1.3.1

Modified:
    continuum/trunk/continuum-docs/   (props changed)
    continuum/trunk/continuum-docs/src/site/apt/installation/upgrade.apt

Propchange: continuum/trunk/continuum-docs/
------------------------------------------------------------------------------
--- svn:ignore (original)
+++ svn:ignore Fri Jan 16 17:11:57 2009
@@ -5,3 +5,4 @@
 *.iml
 *.ipr
 *.iws
+*.tmproj

Modified: continuum/trunk/continuum-docs/src/site/apt/installation/upgrade.apt
URL: http://svn.apache.org/viewvc/continuum/trunk/continuum-docs/src/site/apt/installation/upgrade.apt?rev=735194&r1=735193&r2=735194&view=diff
==============================================================================
--- continuum/trunk/continuum-docs/src/site/apt/installation/upgrade.apt (original)
+++ continuum/trunk/continuum-docs/src/site/apt/installation/upgrade.apt Fri Jan 16 17:11:57 2009
@@ -7,106 +7,66 @@
  Sep 10 2008
  ------
 
-Upgrade
+Upgrading Continuum
 
-* Goal
+    This document will help you upgrade Continuum from 1.2.x to 1.3.x.
 
-    When upgrading Continuum, it could have some database model changes. This tool exports data from old database model and imports the data into the new database model.
+    When upgrading Continuum, it could have some database model changes. The Data Management tool exports data from the
+    old database model and imports the data into the new database model.
 
-    There are 2 databases that need to be converted, one for the builds and one for the users.
-    
-    <<Note>> If you are upgrading from 1.1 to 1.2, no upgrade tool is needed.
-    
-    Due the fix of {{{http://jira.codehaus.org/browse/CONTINUUM-1688}CONTINUUM-1688}} :
-    
-    * if you use mssql server : you have to uncomment lines in a file in the webapp (WEB-INF/classes/META-INF/plexus/application.xml) (search mssql support).
-    
-    * if you use a 1.1 database you have to change manually the size of a column (in order to have the fix) :
-    
-+------------------------------------------+    
--- command tested with derby database
-alter table CHANGESET alter column CHANGECOMMENT SET DATA TYPE varchar(8192)  
-+------------------------------------------+   
+* Upgrading from 1.2.x to 1.3.1
 
-* Download The Tool
+    There are 2 databases that need to be considered:  one for the builds and one for the users.
 
-    The tool is a standalone jar that you can download from the central repo.
+    There were no changes in the users database from 1.2.x to 1.3.1, so you can simply point Continuum 1.3.1 at your
+    existing user database.
 
-    You will need to download 2 versions of the tool, one for the export out of the old version and one for the import into the new version:
+    The builds database has had model changes, and will need to be exported and imported.
 
-        * {{http://repo1.maven.org/maven2/org/apache/maven/continuum/data-management-cli/1.1-beta-3/data-management-cli-1.1-beta-3-app.jar}}
+    First, download the Data Management tools you will need.  The tool is a standalone jar that you can download from the central repo.
 
-        * {{http://repo1.maven.org/maven2/org/apache/maven/continuum/data-management-cli/1.1-beta-4/data-management-cli-1.1-beta-4-app.jar}}
+    You will need to download two versions of the tool, one for the export out of the old version and one for the import into the new version:
 
-        * {{http://repo1.maven.org/maven2/org/apache/maven/continuum/data-management-cli/1.1/data-management-cli-1.1-app.jar}}
-        
-        * {{http://repo1.maven.org/maven2/org/apache/continuum/data-management-cli/1.2/data-management-cli-1.2-app.jar}}
+        * {{http://repo1.maven.org/maven2/org/apache/maven/continuum/data-management-cli/1.2.x/data-management-cli-1.2.x-app.jar}}
 
-    The first version of this tool is 1.1-beta-2
+        * {{http://repo1.maven.org/maven2/org/apache/continuum/data-management-cli/1.3.1/data-management-cli-1.3.1-app.jar}}
 
-* Exporting Data from the old version
+    <<Note:>> The 1.2.2 and 1.2.3 released versions of this tool have a bug.  You will need to use version 1.2.4 of the tool to export databases from those versions.
 
-    Follow these steps:
+    Next, follow these steps to export data from the old version
 
         * Stop the old version of continuum
 
-        * Export the build and user data from the old version using the jar for the old version:
+        * Execute this command to create the builds.xml export file
 
 +------------------------------------------+
-java -Xmx512m -jar data-management-cli-1.1-beta-4-app.jar -buildsJdbcUrl jdbc:derby:${old.continuum.home}/data/continuum/database -mode EXPORT -directory backups
-java -Xmx512m -jar data-management-cli-1.1-beta-4-app.jar -usersJdbcUrl jdbc:derby:${old.continuum.home}/data/users/database -mode EXPORT -directory backups
+java -Xmx512m -jar data-management-cli-1.2.x-app.jar -buildsJdbcUrl jdbc:derby:${old.continuum.home}/data/databases/continuum -mode EXPORT -directory backups
 +------------------------------------------+
 
-* Importing Data to the new version
-
-    Follow these steps:
+    Then, follow these steps to import the data to the new version
 
-        * Start the new version continuum to create the new data model.
 
-        * Stop continuum
+        * Start the new version of Continuum to create the new data model, but do not configure it.
 
-        * Run the specific steps for your version, described below
+        * Stop Continuum
 
-        * Import the build and user data into the new version using the jar for the new version:
+        * Execute this command to import the builds data from the xml file you created earlier:
 
 +------------------------------------------+
-java -Xmx512m -jar data-management-cli-1.1-app.jar -buildsJdbcUrl jdbc:derby:${new.continuum.home}/data/continuum/database -mode IMPORT -directory backups
-java -Xmx512m -jar data-management-cli-1.2-app.jar -usersJdbcUrl jdbc:derby:${new.continuum.home}/data/users/database -mode IMPORT -directory backups
+java -Xmx512m -jar data-management-cli-1.3.1-app.jar -buildsJdbcUrl jdbc:derby:${new.continuum.home}/data/databases/continuum -mode IMPORT -directory backups
 +------------------------------------------+
+        
+        []
+ 
+        Finally, be aware that sometimes the NEXT_VAL values in the SEQUENCE_TABLE need to be adjusted.
 
-        * <<NEXT_VAL values in SEQUENCE_TABLE must be checked before restarting continuum>>
-
-            * Normally, the SEQUENCE_TABLE is ok but in some cases the values are wrong.
-
-            * Before starting Continuum for the first time after the import, connect to the db with a client like {{{http://squirrel-sql.sourceforge.net/}Squirrel SQL}} and check the values in the <<NEXT_VAL>> column.
+            * Before starting Continuum for the first time after the import, connect to the db with a client like {{{http://squirrel-sql.sourceforge.net/}Squirrel SQL}} and check the values in the <<NEXT_VAL>> column of the SEQUENCE_TABLE.
 
             * Values must be greater than the max id value in each table.
 
             * For example, the next value of "org.apache.maven.continuum.model.Project" must be greater than the greatest id in Project table.
 
-        * Start the new version of continuum.
-
-* Specific steps to do before import
-
-** 1.1 import
+        []
 
-    Before to import from an older version (before 1.1-beta-4 to 1.1 final, you must open the builds.xml file under backup directory and remove all <<'testResults'>> tags.
-    You can remove them with the following XSL:
-
-+------------------------------------------+
-<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
-<xsl:output method="xml"/>
- <xsl:template match="testResult"/>
-  <xsl:template match="@*|node()">
-    <xsl:copy>
-      <xsl:apply-templates select="@*|node()"/>
-    </xsl:copy>
-  </xsl:template>
-</xsl:stylesheet>
-+------------------------------------------+
-
-    And you can run it with this command:
-
-+------------------------------------------+
-xsltproc copy.xsl builds.xml > fixed-builds.xml
-+------------------------------------------+
+        Now you can start your new version of Continuum.
+  
\ No newline at end of file