I would recommend https://rrr.se/cgi/tools/main?tool=rrrLoginConv
On Mon, Sep 29, 2014 at 11:02 AM, Frank Caruso <caruso.fr...@gmail.com> wrote: > ITSM 764 sp2, Oracle, Weblogic > > We have been asked to determine the difficulty/feasibility in converting > all Login IDs and Corporate IDs to new values. The unique values currently > used must be eliminated from "every" field in the application: Submitter, > Last Modified By, contained within a notes/description field and all custom > forms. We have over 1 million HPD records and millions of other ancillary > tables; audit, work log, assignments, searches, etc. I looked at the Data > Wizard Console (DWC) and it does allow Login IDs to be changed; it appears > to search across 408 tables in ITSM. But it does not handle corporate id, > can only be run for a single ID, does not search inside text fields and > does not handle custom forms. It also looks like a process that will take a > very long time to run. > > Looking for any thoughts on performing such a task; maybe some tricks > other have come up? > > Thank you. > > Frank Caruso > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
