Page Comparison

...

1. A migrator files a ticket in the Kuali Rice JIRA project requesting migration of a data set to the Rice database. The JIRA ticket should provide a link to the SVN location of the data files.
2. Upon approval, the migrator copies the data set to the <Repository Root/tags/<client release version> directory, citing the Kuali Rice JIRA ticket.

   Code Block
   borderStyle solid title Example:Migrating to <tags>
   svn copy https://svn.ucdavis.edu/svn/kuali/RiceApplications/KualiCoeus/trunk/datasets https://svn.ucdavis.edu/svn/kuali/RiceApplications/KualiCoeus/tags/2.0 -m "<KR JIRA ticket>"

3. Prior to a release, the migrator adds a task (or requests that a task be added) in the Deployment Plan stating that the data set is to be migrated.
4. The Rice Service Manager creates a ticket in the Kuali Rice JIRA project that reflects this task and assigns it to the Rice DBA.
   • Jira ticket should specify the KR_1234_deploy.sql script to execute.
   • Jira Ticket should contain the svn command specifying the repository, tag and release:

     Code Block
     svn co https://svn.ucdavis.edu/svn/kuali/RiceApplications/KualiCoeus/tags/2.0

5. The Rice DBA checks the data set out from the repository.
   • Log onto the appropriate database server
   • cd /opt/pkg/oracle/subversion
   • Execute svn co https://svn.ucdavis.edu/svn/kuali/RiceApplications/<Application>/tags/<release_version> command provided in the Jira Ticket.

     Code Block
     $ svn co https://svn.ucdavis.edu/svn/kuali/RiceApplications/<Application>/tags/<release_version> <Application>

   • This will create an <Application> directory with a <release_version> subdirectory
   • The <release_version> subdirectory will contain script(s) which will be named for the Jira ticket number (eg. KR-1234.sql).
     or

• • cd /opt/pkg/oracle/subversion/<Application> where <Application> is rice_db, MyInfoVault, KualiFinancialSystem, KualiCoeus or TimeReportingSystem
  • Execute svn update
  • cd to /opt/pkg/oracle/subversion/<Application>/tags/<release_version>
  • The <release_version> subdirectory will contain script(s) which will be named for the Jira ticket number (eg. KR-1234.sql).
  • Access Mothra Test DB as environment schema owner noted in Jira ticket and execute script:

    Code Block
    sqlplus <environment schema owner>/<password> @KR_####_deploy.sql

...