How to Connect to SQLAnywhere On Premises from Azure with VPN Tunneling?

[Former Member]

Hi,

We have a SQLAnywehre instance on premises and are attempting to migrate the data into Azure.  An Azure virtual network, site to site connection and permissions are all in place.  SQLAnywhere is installed in an Azure virtual machine running Windows Server 2012 R2.  The physical server does not have a public IP address and is only accessible via VPN.  The goal is to load the data from the on premises instance into a SQL Azure database. 

How do I configure the Sybase Central connection to use the VPN as a tunnel into the physical server?  Are there other tools that should be used instead e.g. Toad for SAP Sybase?  Each time a connection is attempted, an error is given that the database server cannot be found.  Greatly appreciate your help and guidance.

[former_member44015]

Hi ,

In my understanding..

a) On premise : SQL Anywhere is running. ( DB file )

b) Azure virtual machine (Windwos2012R2) : SQL Anywhere ( no DB )  and SQL Azure database.

You can use to copy SQL Anywhere DB file to Azure virtual machine.

And you can run SQL Anywhere using DB files on Azure virtual machine.

Exporting data from SQL Anywhere , please read this manual:

http://dcx.sap.com/index.html#sqla170/en/html/818619946ce210148394eebfbc41e54d.html

Best regards,

Yasutaka Yano