0

I would like to be able to use a database link from an Oracle 10g database to a SQL Azure database.

Will Oracle Heterogeneous Services support this?

I can see various articles relating to connecting to SQL Azure via ODBC, so does this mean that it will be possible to do it using Oracle HS, or am I oversimplifying things?

2 Answers 2

1

If there is an ODBC driver to connect to it, then the Oracle Transparent Gateway for ODBC should work just fine.

0

Since the IP of a SQL Azure server may change over time then the IP address of a SQL Azure server should not be used to create a DB Link.

Hope this helps.

Regards,

Alberto Morillo

2
  • 1
    Of course, it's a bad idea to use the ip address in any database link, SQL Azure or not. The IP of any server is subject to change. Not as often as a workstation with a DHCP address, but still is possible whenever the net admin deems necessary. Use the server name and let DNS sort it out.
    – EdStevens
    Commented Jul 4, 2017 at 23:13
  • Azure SQL uses SNI, IPs changing is the least of your problems when not using hostnames (There are 1-3 fixed IPs per region....) Commented Aug 21, 2019 at 15:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.