Hi everyone, I'm looking to see about some clarification in the documentation. I see the page on how to upgrade from 4.5 to 5.0 here: https://wiki.collectionspace.org/display/DOC/Post-install+step+for+upgrading+to+v5.0 It mentions though: "The next step will erase ALL existing CollectionSpace user data. Do not follow this step if you have existing v4.5 data.  The instructions on this page are only for upgrading a new installation of CollectionSpace v4.5.  There are separate instructions for upgrading from an existing, earlier version of CollectionSpace to v5.0." However I didn't see any instructions on this page. Was it referring to this page? https://wiki.collectionspace.org/display/DOC/Migrating+existing+users+and+roles+to+a+new+CollectionSpace+system Are there any other pages which description on preserving data when upgrading from 4.5 to 5.0? Thank you, Peter

Hi Peter, I suspect that page hasn't been written for the 4.5 to 5.0 upgrade. I'm doing upgrades from 4.1 to 5.0. This is the SQL script I've been using to upgrade an existing database: https://github.com/cspace-deployment/Tools/blob/master/scripts/db/upgrade_4.1_to_5.0.sql I believe the change to the accounts_tenants table happened prior to 4.5, so you probably don't need to do that if you're starting from 4.5. Ray On Wed, Jul 11, 2018 at 12:48 PM Peter Tucker < peter.tucker@granitehorizon.com> wrote: > Hi everyone, > > I'm looking to see about some clarification in the documentation. I see > the page on how to upgrade from 4.5 to 5.0 here: > > > https://wiki.collectionspace.org/display/DOC/Post-install+step+for+upgrading+to+v5.0 > > > It mentions though: > "The next step will erase ALL existing CollectionSpace user data. Do not > follow this step if you have existing v4.5 data. The instructions on > this page are only for upgrading a new installation of CollectionSpace > v4.5. There are separate instructions for upgrading from an existing, > earlier version of CollectionSpace to v5.0." > > However I didn't see any instructions on this page. Was it referring to > this page? > > https://wiki.collectionspace.org/display/DOC/Migrating+existing+users+and+roles+to+a+new+CollectionSpace+system > > > Are there any other pages which description on preserving data when > upgrading from 4.5 to 5.0? > > Thank you, > Peter > > > _______________________________________________ > Talk mailing list > Talk@lists.collectionspace.org > > http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org >

 Hi everyone,

 I'm looking to see about some clarification in the documentation.
 I see
 the page on how to upgrade from 4.5 to 5.0 here:

 https://wiki.collectionspace.org/display/DOC/Post-install+step+for+upgrading+to+v5.0



 It mentions though:
 "The next step will erase ALL existing CollectionSpace user data.
 Do not
 follow this step if you have existing v4.5 data.  The instructions on
 this page are only for upgrading a new installation of
 CollectionSpace
 v4.5.  There are separate instructions for upgrading from an
 existing,
 earlier version of CollectionSpace to v5.0."

 However I didn't see any instructions on this page. Was it
 referring to
 this page?
 https://wiki.collectionspace.org/display/DOC/Migrating+existing+users+and+roles+to+a+new+CollectionSpace+system



 Are there any other pages which description on preserving data when
 upgrading from 4.5 to 5.0?

 Thank you,
 Peter


 _______________________________________________
 Talk mailing list
 Talk@lists.collectionspace.org <mailto:Talk@lists.collectionspace.org>
 http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org

Thanks Ray! This looks super useful, thank you! My only follow up question is when to perform this in relation to the upgrade steps for 5.0.  My first impression is: -Stop 4.5 instance -Create backups of current database tables -Run the sql script you linked to -Update application and services directories code to use the 5.0 branch version . -Under application, run "mvn clean install -DskipTests" -Under services, run "ant undeploy deploy" -Skip the directions to use "ant create_db -Drecreate_db=true import" (to avoid deleting data) -Create "security.properties" file under "/use/local/share/apache-tomcat-7.0.64/lib" -Follow the rest of the directions to download and install the new CollectionSpace v5.0 code (on the upgrade link in my last email). Is this correct? Feel free to correct on the steps or if I'm missing something. Thank you, Peter On 07/11/2018 02:13 PM, Ray Lee wrote: > Hi Peter, > I suspect that page hasn't been written for the 4.5 to 5.0 upgrade. > I'm doing upgrades from 4.1 to 5.0. This is the SQL script I've been > using to upgrade an existing database: > https://github.com/cspace-deployment/Tools/blob/master/scripts/db/upgrade_4.1_to_5.0.sql > > I believe the change to the accounts_tenants table happened prior to > 4.5, so you probably don't need to do that if you're starting from 4.5. > > Ray > > On Wed, Jul 11, 2018 at 12:48 PM Peter Tucker > <peter.tucker@granitehorizon.com > <mailto:peter.tucker@granitehorizon.com>> wrote: > > Hi everyone, > > I'm looking to see about some clarification in the documentation. > I see > the page on how to upgrade from 4.5 to 5.0 here: > > https://wiki.collectionspace.org/display/DOC/Post-install+step+for+upgrading+to+v5.0 > > > > It mentions though: > "The next step will erase ALL existing CollectionSpace user data. > Do not > follow this step if you have existing v4.5 data.  The instructions on > this page are only for upgrading a new installation of > CollectionSpace > v4.5.  There are separate instructions for upgrading from an > existing, > earlier version of CollectionSpace to v5.0." > > However I didn't see any instructions on this page. Was it > referring to > this page? > https://wiki.collectionspace.org/display/DOC/Migrating+existing+users+and+roles+to+a+new+CollectionSpace+system > > > > Are there any other pages which description on preserving data when > upgrading from 4.5 to 5.0? > > Thank you, > Peter > > > _______________________________________________ > Talk mailing list > Talk@lists.collectionspace.org <mailto:Talk@lists.collectionspace.org> > http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org >

Hi Peter, The only step I'd change is that you do need to run the ant import target, just not the create_db. So instead of "ant create_db -Drecreate_db=true import", do "ant import". (The create_db target is the one that's destructive. The import is additive.) Also do make sure the steps in my SQL script make sense for your 4.5 database. In particular the update to tenants_accounts_common_csid might actually cause you to lose data if that column already exists. Or it might just error, if tenants_accountscommon_csid doesn't exist. Ray On Wed, Jul 11, 2018 at 3:22 PM Peter Tucker < peter.tucker@granitehorizon.com> wrote: > Thanks Ray! > > This looks super useful, thank you! My only follow up question is when to > perform this in relation to the upgrade steps for 5.0. My first impression > is: > > -Stop 4.5 instance > -Create backups of current database tables > -Run the sql script you linked to > -Update application and services directories code to use the 5.0 branch > version . > -Under application, run "mvn clean install -DskipTests" > -Under services, run "ant undeploy deploy" > -Skip the directions to use "ant create_db -Drecreate_db=true import" (to > avoid deleting data) > -Create "security.properties" file under > "/use/local/share/apache-tomcat-7.0.64/lib" > -Follow the rest of the directions to download and install the new > CollectionSpace v5.0 code (on the upgrade link in my last email). > > Is this correct? Feel free to correct on the steps or if I'm missing > something. > > Thank you, > Peter > > > On 07/11/2018 02:13 PM, Ray Lee wrote: > > Hi Peter, > I suspect that page hasn't been written for the 4.5 to 5.0 upgrade. I'm > doing upgrades from 4.1 to 5.0. This is the SQL script I've been using to > upgrade an existing database: > https://github.com/cspace-deployment/Tools/blob/master/scripts/db/upgrade_4.1_to_5.0.sql > > I believe the change to the accounts_tenants table happened prior to 4.5, > so you probably don't need to do that if you're starting from 4.5. > > Ray > > On Wed, Jul 11, 2018 at 12:48 PM Peter Tucker < > peter.tucker@granitehorizon.com> wrote: > >> Hi everyone, >> >> I'm looking to see about some clarification in the documentation. I see >> the page on how to upgrade from 4.5 to 5.0 here: >> >> >> https://wiki.collectionspace.org/display/DOC/Post-install+step+for+upgrading+to+v5.0 >> >> >> It mentions though: >> "The next step will erase ALL existing CollectionSpace user data. Do not >> follow this step if you have existing v4.5 data. The instructions on >> this page are only for upgrading a new installation of CollectionSpace >> v4.5. There are separate instructions for upgrading from an existing, >> earlier version of CollectionSpace to v5.0." >> >> However I didn't see any instructions on this page. Was it referring to >> this page? >> >> https://wiki.collectionspace.org/display/DOC/Migrating+existing+users+and+roles+to+a+new+CollectionSpace+system >> >> >> Are there any other pages which description on preserving data when >> upgrading from 4.5 to 5.0? >> >> Thank you, >> Peter >> >> >> _______________________________________________ >> Talk mailing list >> Talk@lists.collectionspace.org >> >> http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org >> > >