on 2011 May 12 2:44 AM
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??
Request clarification before answering.
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".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
87 | |
10 | |
9 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.