We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Script to reset demo database

Script to reset demo database
Could I get a copy of the script used to reset the Akaza OpenClinica demo database each Sunday. I need to clear out our local demo database, and the Akaza script would be very useful as a starting point.
Thanks,
Cynthia Pepper
Software Engineer
Department of Radiological Sciences
St. Jude Children's Research Hospital
332 North Lauderdale Street
Memphis, TN 38105-2794
901.495.4923 tel
901.495.3981 fax
[email protected]

Comments

  • Hello Cynthia,

    Currently, Akaza creates a set of 4 scheduled tasks to reset OpenClinica_public demo on Window.


    1. shutdown tomcat

    c:\tomcat5\bin\shutdown.bat

    2. Reload Database

    pg_restore -U postgres -c -d openclinica_public \OpenClinica_Sample.backup

    3. Reset OpenClinica.data

    C:\openclinicadata_reset.bat

    4. Startup Tomcat

    C:\tomcat5\bin\startup.bat



    ---- Openclinicadata_reset.bat

    rmdir c:\tomcat5\openclinica_public.data /s /q
    mkdir c:\tomcat5\openclinica_public.data
    xcopy c:\openclinica.data c:\tomcat5\openclinica_public.data /s /q


    ---- we created a database backup file in advance

    ---- we created a default “openclinica.data” directory in advance



    Regards,
    Yufang Wang
    Akaza Research
    400 One Kendall Square
    Cambridge, MA 02139
    tel: 617.621.8585 x.26
    www.akazaresearch.com
    www.openclinica.org
    Open Source Platform for Clinical Research
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    Sent: 9.January.2008 11:06
    To: [email protected]
    Subject: [Developers] Script to reset demo database

    Could I get a copy of the script used to reset the Akaza OpenClinica demo database each Sunday. I need to clear out our local demo database, and the Akaza script would be very useful as a starting point.
    Thanks,
    Cynthia Pepper
    Software Engineer
    Department of Radiological Sciences
    St. Jude Children's Research Hospital
    332 North Lauderdale Street
    Memphis, TN 38105-2794
    901.495.4923 tel
    901.495.3981 fax
    [email protected]
This discussion has been closed.