Thanks for this.
Also as I said the aim is to lower the number of connection to the production environment as it is used by our employees (250 persons) through our third party software provider.
That's why we wanted to deflect all other tools connections to a secondary database server.
Thank you for your answer.
The database is version 11.10.0.24 which is no longer maintained (we can't do anything on this as this is used by a third party software) on Windows OS.
I'll get answers to your other questions from my sysadmin.
Thanks.
I'm building a POC here so please give your recommendation and I'll give it a try respecting everything you advise.
As I said I don't even know if this is doable so please advise :)
Thanks.
Hi,
For some reasons (very old database engine that does not allow replicating nor anything) which I can't change, I need a workaround to lower the number of connections to my main database server.
So I want to keep only my integrated management software with read/write access to the database...