Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Transactions between databases...

2 posts in General Discussion Last posting was on 2004-11-29 12:59:32.0Z
Tom Houser Posted on 2004-11-29 12:42:16.0Z
Sender: 16ba.41ab187c.1804289383@sybase.com
From: Tom Houser
Newsgroups: ianywhere.public.general
Subject: Transactions between databases...
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41ab1928.16c4.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Nov 2004 04:42:16 -0800
X-Trace: forums-1-dub 1101732136 10.22.241.41 (29 Nov 2004 04:42:16 -0800)
X-Original-Trace: 29 Nov 2004 04:42:16 -0800, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3915
Article PK: 7812

I have two SQL Anywhere databases running on the same box
under the same service. Is there a way to allow one
database to pull data from another? I'm hoping to do this
via some sort of scheduled event.

Thanks,

Tom Houser


Chris Keating (iAnywhere Solutions) Posted on 2004-11-29 12:59:32.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <41ab1928.16c4.1681692777@sybase.com>
Subject: Re: Transactions between databases...
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <41ab1d34$1@forums-1-dub>
Date: 29 Nov 2004 04:59:32 -0800
X-Trace: forums-1-dub 1101733172 10.25.98.199 (29 Nov 2004 04:59:32 -0800)
X-Original-Trace: 29 Nov 2004 04:59:32 -0800, keating-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3917
Article PK: 7809

You can use remote servers and proxy tables for this (assuming you are
running a version that supports these features).

<Tom Houser> wrote in message news:41ab1928.16c4.1681692777@sybase.com...
>I have two SQL Anywhere databases running on the same box
> under the same service. Is there a way to allow one
> database to pull data from another? I'm hoping to do this
> via some sort of scheduled event.
>
> Thanks,
>
> Tom Houser