Connection between two databases

[Former Member]

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??

[reimer_pods]

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

[VolkerBarth]

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".

[Former Member]

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

[VolkerBarth]

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.