search

visulate / visulate-ora2pg

Docker image and single page web application for Ora2Pg
Apache License 2.0
29 stars 10 forks source link

Add option to log to file #114

Open oraculix opened 1 month ago

oraculix commented 1 month ago

First of all: Thank you for sharing your work with the community! It is quite helpful in iterating towards an optimized (and working) ora2pg.conf.

The issue I have when monitoring a running migration in the browser, a glitch in the network connection (or simply an accidental reload) "loses" the event stream.

Particularly for long-running migrations there should be an option to log to a file in the project directory.

Cheers, Uwe

pgoldtho commented 1 month ago

One way to achieve this for tasks that you are expecting to take a long time would be to call ora2pg directly using the docker image that visulate-ora2pg is using - https://github.com/Guy-Incognito/ora2pg

Use the export button in visulate-ora2pg to download an ora2pg.conf file and then pass its location as a CONFIG_LOCATION environment variable

docker run  \
    --name ora2pg \
    -e CONFIG_LOCATION=/config/myconfigfile.conf  \
    -e OUTPUT_LOCATION=/data/myfolder  \
    -e ORA_HOST=dbi:Oracle:host=mydb.mydom.fr;sid=SIDNAME;port=1521  \
    -e ORA_USER=system  \
    -e ORA_PWD=secret  \
    -it \
    -v /path/to/local/config:/config \
    -v /path/to/local/data:/data \
    georgmoser/ora2pg
oraculix commented 1 month ago

Sounds interesting, thanks. Just to double check: This solution is not possible with your container and needs the separate ora2pg container you mentioned, correct?