|
Home > Archive > SQL Anywhere database > May 2005 > How can I select from one database and insert into another ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How can I select from one database and insert into another ?
|
|
| Karl Tarbet 2005-05-27, 11:23 am |
| I need to copy data, using a query, from one database to
another
Does ASA 9.0 support something like:
insert into db1.owner.table
(select id,data1,data2 from db2.owner.table where id
between(1 and 300) )
where db1 is a different database from db2. Both databases
are on the same database server.
Thanks, karl
| |
| Thomas Auer 2005-05-27, 11:23 am |
| I make this via the "proxy"-table feature.
In the german documentation it is called "Auf die Daten anderer Datenbanken
zugreifen"
Search in the online documention for "proxy"
Thomas
<Karl Tarbet> schrieb im Newsbeitrag
news:4297355f.1130.1681692777@sybase.com...
>I need to copy data, using a query, from one database to
> another
> Does ASA 9.0 support something like:
> insert into db1.owner.table
> (select id,data1,data2 from db2.owner.table where id
> between(1 and 300) )
> where db1 is a different database from db2. Both databases
> are on the same database server.
> Thanks, karl
| |
| Greg Fenton 2005-05-27, 11:23 am |
| Karl Tarbet wrote:
> I need to copy data, using a query, from one database to
> another
The technology used to connect an ASA database to another database
(note: not necessarily another ASA db!!) is called Remote Data Access.
The technology of connecting remote tables is called Proxy Tables.
In the ASA 9.x online docs see:
ASA SQL User's Guide
- Accessing Remote Data
Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
|
|
|
|
|