Enable Server Events logging for all the different types of objects before your upgrade and then do a report on the Server Events form after your upgrade. You won't get low-level details of what changed, but it will tell you what kind of change it was at a high level. You'll need to refer to the "Configuring" guide to extrapolate the type of changes involved. I created a Crystal Report that has formulas to convert all of that so I can run that report and quickly see what has been changed.
To get real details, I created some SQL scripts that compare the data dictionary of two ARSystem databases (presumably one that is upgraded, one that is not) to identify differences. This lets me see some detailed form and field differences such as: Forms - created, removed, changed (permissions, indexes, results list, views) Fields - created, removed, changed (permissions, field properties, field name) It was very handy after our 6.3-to-7.0.1 upgrade. I didn't catch everything, but I caught a lot more than I otherwise would have. Chad Hall (501) 342-2650 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Wednesday, September 17, 2008 1:49 PM To: [email protected] Subject: Re: Easy way to find changes after an upgrade? Doesn't sorting the objects by Modified Date give you that list? Or are you looking for a printable list? You could get a printable list by selecting your forms from arschema table, active links from actlink table, filters and escalations from the filter table and menus from the char_menu table. If you want to go a little more granular, and get the list of all newly created fields, you could browse the field table and get the new list of fields created for every schema ID.. Joe ----- Original Message ---- From: SUBSCRIBE arslist Melissa <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, September 17, 2008 2:27:07 PM Subject: Easy way to find changes after an upgrade? ** Is there an easy way to get a list of all the objects that have changes after a patch or an upgrade? __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ *************************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. **************************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
