cancel
Showing results for 
Search instead for 
Did you mean: 

Connection between two databases

3,533

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

Accepted Solutions (0)

Answers (1)

Answers (1)

VolkerBarth
Contributor

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

0 Kudos

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

VolkerBarth
Contributor
0 Kudos

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.