apptools-sqlgateway-demo

An example repository using PostgreSQL SQLgateway to demonstrate exporting and importing instances of the %Library.SQLConnection class with copying jdbc drivers. This is especially useful when you want to copy items to another iris server through the package manager's private registry while keeping your private settings.

Credits

0. OEX package migration-pg-iris-dataset provided by YURI MARX PEREIRA GOMES

   • Special thanks as this was an excellent base to start off.

1. Article about PostgreSQL into Docker:

   • https://levelup.gitconnected.com/creating-and-filling-a-postgres-db-with-docker-compose-e1607f6f882f

2. Git project created from:

   • https://github.com/jdaarevalo/docker_postgres_with_data
   • https://github.com/intersystems-community/iris-docker-zpm-usage-template

3. OEX package db-migration-using-SQLgateway provided by Robert Cemper

   • Thank you so much as this is a great project to learn and practice new skills.

Prerequisites

Make sure you have git and Docker desktop installed.

Installation

Clone/git pull the repo into any local directory

git https://github.com/SergeyMi37/apptools-sqlgateway-demo.git

1. Build

docker-compose build

2. Run it in foreground. Sometimes container start is slower than estimated.

docker-compose up