Hi, I have a free command line tool called RRR|LoginConv. This was designed to convert one or more login-name to another throughout the database.
It can be used for any type of conversion. You specify a maximum size for the fields to be checked, as well as a conversion list such as: Joe's Computers = Joseph's Computers If any field contains an exact match for the source field data, it will be merged back with the new name. This will ensure that no modify-date etc is triggered. The tool will warn for any merge-filters that may damage your data. https://www.rrr.se/cgi/tools/main#rrrLoginConv It will take some time to run, but will only "merge" those actual columns that need change. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > Hello All, > I am getting several requests to change the Company field in version > 7.0.01 > Ex. Joe's Computers is now changing it's name to Joseph's Computers. > > > > Field ID 1000000001. > When I search this field ID in ARutilities, it returns 417 references to > that field. > > Has anyone come up with a way to change Company name and ensure it is > propogated throughout the database? > > Other than a monster SQL script to update the field in all locations, I > don't think this is possible. > My current answer to this question is: Set Joe's computers to "Obsolete" > and > recreate as "Joseph's Computers". > But then we lost historical reporting data, etc. > > Has anyone else encountered this? I just thought we couldn't possibly be > the > only company who has dealt with this situation. > > 7.0.01 Unpatched > SQL Server 2005 > > Thanks, > > Jase > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
