The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

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
1279913
accept rate: 0%

edited 14 May '11, 12:02

Volker%20Barth's gravatar image

Volker Barth
30.9k309457667

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.9k309457667
accept rate: 33%

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:

×63
×46

question asked: 12 May '11, 01:44

question was seen: 1,713 times

last updated: 14 May '11, 12:02