Backup ETL Validator Repository/Workschema
ETL Validator Complete comes with an embedded PostgreSQL database that is used as the Repository & Workschema. If you are upgrading ETL Validator Complete, please follow these steps to take backup of the database prior to the upgrade:
- Make a copy of the 'data' directory of the postgres database. Below is the location of this directory for ETL Validator Complete:
C:\app\Datagaps\ETLValidator\pgsql\data
Upgrading ETL Validator Complete
ETL Validator Complete can be upgrade very easily by following these three simple steps:
- Stop the service called 'Datagaps ETL Validator Server' from Windows Services
- Uninstall ETL Validator. During the uninstall the PostgreSQL repository is still preserved. So you will not loose the test cases and data sources you already created.
- Install the latest build of ETL Validator
Upgrading ETL Validator Server Deployed in Apache Tomcat
In Multi-user deployment, ETL Validator Server may be deployed in a standalone apache tomcat instance. Below are the steps to upgrade the ETL Validator Server in such cases:
- Stop Apache Tomcat from Windows Services or command line
- Remove the two folders 'ETLValidatorServer' and 'ETLValidatorService'
- Copy the two war files 'ETLValidatorServer.war' and 'ETLValidatorService.war'
- Restart Tomcat from Services
Upgrading ETL Validator Client
To upgrade ETL Validator Client, just uninstall and reinstall it.