You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Introduction

If you want to change your used DB System in custo diagnostic you have to move the custo diagnostic Database to another DB System. This can be necessary if your custo diagnostic Database exeeds the 10 GB limit and you use an Microsoft SQL Server Express.

This procedure is not suiteable if you want to move your custo diagnostic Database to another Computer (with the same DB System).

Preparation

To move the custo diagnostic Database to another DB System you have to prepare your setup to this situation:

  • running custo diagnostic System connected to the previous DB System
  • installed, running and configured new DB System with empty custo diagnostic Database

Its not necessary to prepare a separate cst File folder because the cst Files will not be moved.

Move the Database

  1. Create a copy of the "diag.properties" File
    The diag.properties file contains the database connector. The "diag.properties" File is located in the Folder "<diag server Root>\conf". Rename the copied File to "diag.properties.old".
  2. Reconfigure your custo diagnostic server to the new DB System.
    You can do the reconfiguration by manual if you rewrite the DB connector in the diag.properties file. As an alternative you can uninstall the custo diagnostic server and reinstall with other DB System settings. This procedure creates the destination "diag.properties" File which is to be used afterwards.
    Please Note: If you uninstall/reinstall the custo diagnostic server you have to backup and restore the diag.properties.old file.
  3. Please check that your setup is running with the new DB System.
    Please Note: Don't create any new Patients or Evaluations!
  4. Stop the custo diagnostic server (stop the Tomcat)
  5. Please check that the "diag.properties" and "diag.properties.old" Files are available in the "<diag server Root>\conf" Folder
  6. Run the DatabaseConverter Script
    1. Open a Command Line Window
    2. Change the active Folder to "<diag server Root>" (Default: "C:\Program Files\custo diagnostic server")

    3. Insert this Code and execute:

      .\jre\bin\java.exe -classpath "webapps\diag\WEB-INF\classes;webapps\diag\WEB-INF\lib\*" de.customed.orm.convert.DatabaseConverter --source=conf\diag.properties.old --destination=conf\diag.properties
  7. Wait until the system prompt comes back. During the copy procedure the command line window will display all copy steps.
  8. Start the custo diagnostic server (start the Tomcat)
  9. Check if all Data are vailable.
  • No labels