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?? asked 12 May '11, 01:44 thaerlb Volker Barth |
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". answered 12 May '11, 03:59 Volker Barth where can i find remote data access,and how can i handled???
(12 May '11, 04:05)
thaerlb
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.
(12 May '11, 04:22)
Volker Barth
|
IMHO supplying more detailed information about your goals would be helpfull.