This page describes what the migration script is, and how to execute it when the OAGIS Repository database image which built by Docker, oagi1docker/srt-repo (srt-repo for short), needs to be updated.

When we release the updated version of our application, SRT, sometimes the existing database schema and initial data which kept on your machine by the Docker volume need to be also updated. Since the srt-repo image was designed such that the the schema and data are initialized only when the volume is empty, your existing installation will not be affected even if you change the srt-repo tag.

Thus, we provide the method to keep consistency with updated releases by a file written in the vendor-specific SQL, namely the migration script, which consists of DDL and DML statements.

When we announce the updated release in need of updating the database schema and data, we will update the script location in this page.

• Justransform_08212017 to 1.0: mig_ Justransform_08212017_to_1.0_oracle.sql
• 1.0.0 to 1.1.0: mig_1.0_to_1.1_oracle.sql

• 1.0.0 to 1.1.0: mig_1.0_to_1.1_mysql.sql
• 1.1.0_0 to 1.1.0_3d: mig_1.1.0_0_to_1.1.0_3d_mysql.sql
• 1.1.0_3d to 1.1.1.2d: mig_1.1.0.3d_to_1.1.1.2d_mysql.sql
• 1.1.2.x to 1.1.2.3: mig_1.1.2_to_1.1.2.3_mysql.sql
• 1.1.2.3 to 1.2.0: mig_1.1.2.3_to_1.2.0.sql
• 1.2.0 to 1.3.0: mig_1.2.0_to_1.3.0.sql
• 1.3.0 to 1.4.0: mig_1.3.0_to_1.4.0.sql
• 1.4.0 to 1.5.0: mig_1.4.0_to_1.5.0.sql
• 1.5.0 to 1.6.0: mig_1.5.0_to_1.6.0.sql
• 1.6.0 to 1.7.0: mig_1.6.0_to_1.7.0.sql

• 10.5 to 10.6: oagis_10_5_to_10_6.sql
• Patch 10.5 to 10.6: patch_oagis_10_5_to_10_6.sql

Note that if you have an experience executing the migration script, you can skip this section.

You can execute the migration script using SQL clients such as the Oracle SQL Developer. If you don't have Oracle SQL Developer installed, please download and install it on your HOST machine. The following is the instruction to execute the migration script in the Oracle SQL Developer. If you are using other SQL clients, you might find the process to be similar but it is not covered here.

1. Open Oracle SQL Developer and create a connection to SRT database within the docker container. If a connection already exists simply make the connection and skip the rest of this step.

[Create Connection Menu]
Create Connection Menu

[New / Select Database Connection]

• Username: oagi
• Password: oagi
• Hostname:
  localhost (if you use the Docker CE, a newer Docker distributed binary)
  192.168.99.100 (if you use the Docker Toolbox, but it might be different under your circumstances)
• Port : 1521
• SID : XE

2. Open the migration script file

• Click File > Open menu.
• Choose the migration script file.

3. Run statements

• Click Run Script button which located on the left-upper side.