I wasn’t sure what the subject should really be so I just used some keywords. I’ve not the following before so I thought I’d ask for some terse steps which I can research. Point me in the right direction and I’ll find my way :)
I want to copy some dbs to a backup server. If server 1 fails—power supply dies for example—server 2 will immediately take over. What are considered the best practices to sync db files in real-time from server 1 to server 2? Thankyou.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.