Frex, If you look at the install document for Analytics, I think there is a part if the installation where it's like a manual option. I will look for you when I get a chance. In that area, it goes into detail about where the def files, SQL scripts exist. You shouldn't have to always run the installer.
Sent from my iPhone > On Oct 3, 2013, at 11:46 PM, Frex Popo <frexp...@yahoo.fr> wrote: > > ** > Hello all, > I have Analytics 7.6.06 installed in my development environment (Oracle > database) and need to refresh it with a copy from production. That would mean > losing all the objects (package, functions, stored procs, tables, views > etc.). Is there any way I could rerun manually all the .sql scripts in the > installation package to restore the schema, or is the only way to restore is > by reinstalling analytics again? > My second question would be, how about if I want to make my Analytics/BO > installation point to a different Remedy database, could I BO ODBC to point > to the new database and also run the SQL scripts or do I have to reinstall > again? > I am finding the option of reinstalling tedious and problematic so would > appreciate if anyone who attempted this can shared their thoughts. > Best Regards > frex > _ARSlist: "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"