Moving to uPortal 4.1 from uPortal 4.0

Upgrading your portal can be a trying experience, but maybe some notes and some stories from others can make things better:

University of Wisconsin - Madison

1. Create the db difference script.  Outlined: https://github.com/Jasig/uPortal/pull/417
   1. This will create a DDL script that you can then run on your database to update the schema
      1. This means that you don't have to do an import/export.
      2. Make sure you create the script for all the portalDB and the RawStatsDB
   2. To run, you checkout the 4.1 version of the codebase and point the db connections to your existing 4.0 db.  Calling the ant command from step 1, you'll receive an output file that contains the sql needed to upgrade your databse.
2. Run the db difference script against your database

3. add in update to the up_version table to script for portalDb

   update up_version
   set minor_ver = 1,
   patch_ver = 1,
   local_ver = 5;
   commit;
   select * from up_version;

4. Push the code out to the environment and enjoy!
5. the email lists are a great place to ask any questions!  Please share your migration story too!