Frex, Nevermind. I was thinking about something different... more along the lines of pointing Analytics to a replicated DB. You have to run the installer in order to get at those scripts and files. If you have the install logs, you may be able to go through them and see specifically which objects are being imported.
On Fri, Oct 4, 2013 at 7:45 AM, Tauf Chowdhury <[email protected]> wrote: > 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 <[email protected]> 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_ > > -- *Tauf Chowdhury * _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
