But what about Windows?
I was recently asked ‘Well that’s great, but what about Windows ?’
I don’t come across on Oracle on Windows as much as I may have done in the past, but that got my thinking could I port ORCA to Windows.
So I sourced a couple of Windows 2019 Servers, installed the Oracle binaries and created a source database ready for porting my Ansible playbook to Windows.
Below is a short (edited) video of ORCA for Windows initiated from my Linux Ansible control machine.
In the video I create a record in my source Oracle on Windows database using SQL Developer, run my Ansible playbook and then validate the newly created record is visible in my refreshed target database.
My next job is to tidy-up the code, create a GitHub repo for ORCA for Windows and upload the code, I will then look at creating a more detailed blog on how it works.
Let me know what you think, enjoy!