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's gravatar image

thaerlb
1278912
accept rate: 0%

edited 14 May '11, 12:02

Volker%20Barth's gravatar image

Volker Barth
30.0k294449654

3

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

(12 May '11, 03:58) Reimer Pods

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

permanent link

answered 12 May '11, 03:59

Volker%20Barth's gravatar image

Volker Barth
30.0k294449654
accept rate: 32%

edited 12 May '11, 04:00

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×62
×46

question asked: 12 May '11, 01:44

question was seen: 1,663 times

last updated: 14 May '11, 12:02