move to archive
Sample repository to show how to migrate from PostgreSQL to InterSystems IRIS
using SQLgateway in differnce to using an external tool as DBeaver or similar.
I especially try to demonstrate the comfort in fitting underlaying naming limitations.
Article about PostgreSQL into Docker:
Git project created from:
Clone/git pull the repo into any local directory
postgres_1 | 2022-01-02 15:37:27.654 UTC  LOG: database system is ready to accept connections
Use DBeaver to connect to the databases
SQLgateway is installed during Docker build and the required
jdbcdriver for Linux is included in this repo
In order to make this demo faster, size of tables to migrate have been shrinked a bit.
All migration actions can be executed directly from SMP.
Verify the gateway connection in
SMP> Administration> Configuraation >Connectivity >SqlGateway_Configuration
Identifying the source tables. In SMP > Change to Namespace USER
then step to SMP >Explorers >SQL >Wizards > Data Migration
Set required import parameters
Skipping special setting we use defaults we start the task in background
Now we check the results and see everything was working without Errors
You might see errors if tables depend on content not yet migrated.
And wait for completions until the status shows Done
We terminate the Migration Wizzard and return to normal table view filtered by dc*
All 8 tables are visible and show meaningful columns
Selecting a table and clicking on OpenTable shows resonable contents
A look into the related generated Class Defnitions confirms the result and successful completion.
move to archive
clean up repo