Migration of the data of YADE Background Service and History Viewer which use new database tables

YADE Background Service and History Viewer use new database tables. These tables are

• JADE_FILES
• JADE_FILES_HISTORY
• JADE_FILES_POSITIONS

which are created by the JobScheduler setup

Previously the "old" tables were

• SOSFTP_FILES
• SOSFTP_FILES_HISTORY
• SOSFTP_FILES_POSITIONS

If you used the YADE Background Service in the past and you want to migrate the data from the old SOSFTP_* tables to the new JADE_* tables then use the SQL script ./db/<dbms>/sosftphistory_to_jadehistory_rename.sql from the attached archive. Further this script is provided by the JobScheduler setup but the setup don't call it because it needs few minutes depends on the number of rows in the database.

This SQL script works only if the "new" JADE_* tables don't exist.
It is recommened that you call the attached script before you execute the JobScheduler setup.

• download the attached archive
• extract the archive in the SCHEDULER_HOME directory.
• open a command prompt and call in the working directory SCHEDULER_HOME/install

  • ./scheduler_install_tables.sh sosftphistory_to_jadehistory_rename.sql

  • or

  • scheduler_install_tables.cmd sosftphistory_to_jadehistory_rename.sql

If you have already installed a JobScheduler 1.10 then you have to drop the "new" tables before you call the ./db/<dbms>/sosftphistory_to_jadehistory_rename.sql
For Postgres and Oracle you have to drop the sequence JADE_FILES_ID_SEQ too.

• open a SQL client and execute

• DROP TABLE JADE_FILES;
  DROP TABLE JADE_FILES_HISTORY;
  DROP TABLE JADE_FILES_POSITIONS;
  DROP SEQUENCE JADE_FILES_ID_SEQ;