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"