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

Compare with Current View Page History

« Previous Version 6 Next »

Introduction

If you want to change your used DB System in custo diagnostic you have to migrate 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.
For this procedure you have to use the Database Converter. For the Database Converter no separate software is necessary. The Database Converter is built in the custo diagnostic server.
(warning) Note: You can use this procedure also if you want to move your custo diagnostic Database to another computer with another or the same DB system. (Example: local MariaDB → MariaDB on dedicated Computer)

Preparation

To migrate 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
  • custo diagnostic server Version must be at least 5.1.0
  • 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 migrated.

Migrate 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. You can use this alternative if you want to use the custo diagnostic database on the same compßuter. 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.
    (warning) Note: Don't create any new patients or evaluations at this time!
     
  4. Stop the custo diagnostic server (stop the Apache Tomcat Windows Service)
     
  5. Please check that the "diag.properties" and "diag.properties.old" files are available in the "<diag server Root>\conf" folder
     
  6. Run the Database Converter Script
    1. Open a cmd
    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 -Xmx6g
  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 Apache Tomcat Windows Service)
     
  9. Open the custo diagnostic client and check that all data is available.
  • No labels