Question Re: Connection between two databases in Technology Q&A

Connection between two databases

Former Member — Thu, 12 May 2011 01:44:54 GMT

I have two databases located so far and i want to exchange data between them (i use sybase sqlanywhere 8), so how can i do it??

Re: Connection between two databases

reimer_pods — Thu, 12 May 2011 03:58:06 GMT

IMHO supplying more detailed information about your goals would be helpfull.

Re: Connection between two databases

VolkerBarth — Thu, 12 May 2011 03:59:27 GMT

You will use SQL Anywhere's "Remote data access" feature (aka proxy tables).

The following question and its answers may be of help.

Note: When using SQL Anywhere 8, the server class is called "asaodbc", not "saodbc".

Re: Connection between two databases

Former Member — Thu, 12 May 2011 04:05:58 GMT

where can i find remote data access,and how can i handled???

Re: Connection between two databases

VolkerBarth — Thu, 12 May 2011 04:22:06 GMT

Remote data access is a builtin feature installed by default.

For the v8 docs, there's the following doc:

Adaptive Server Anywhere SQL User's Guide Chaper 15: Accessing Remote Data

For newer versions, you can lookup here (and the basics are still the same).

The question I have cited should give you a starting point. Usually you will create a ODBC Data Source for the 2nd database ("db2") on the box where the 1st database ("db1") is located.

Then you can use the cited steps to create a server for the db2 database and create proxy tables for all tables from db2 you want to access from db1.