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.

Proxy to 5.2? database

3 posts in General Discussion Last posting was on 2006-06-23 15:58:08.0Z
Steve Rhiner Posted on 2006-06-23 03:04:00.0Z
Reply-To: "Steve Rhiner" <rhiner4022000_removethisbit@yahoo.com>
From: "Steve Rhiner" <rhiner4022000_removethisbit@yahoo.com>
Newsgroups: ianywhere.public.general
Subject: Proxy to 5.2? database
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
NNTP-Posting-Host: ool-4356539c.dyn.optonline.net
X-Original-NNTP-Posting-Host: ool-4356539c.dyn.optonline.net
Message-ID: <449b5a20$1@forums-1-dub>
Date: 22 Jun 2006 20:04:00 -0700
X-Trace: forums-1-dub 1151031840 67.86.83.156 (22 Jun 2006 20:04:00 -0700)
X-Original-Trace: 22 Jun 2006 20:04:00 -0700, ool-4356539c.dyn.optonline.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5461
Article PK: 1507

I have an app on the drawing board that will need occaisonal data from a 5.2
(I think, maybe 5.1??) SQLA database. The app will primarily use a 9.0.2
database. I was thinking to use proxy tables get data the old db to the
new one.

I don't think there will be a need to write to the old db. And I think
amount of data transfered will be pretty small, and not particulary
volatile.

The two servers are about a million miles apart -- and communication between
them will be across the internet. (They are actually only about 3 miles
apart, but the point is that they are not in the same place.)

I'm thinking proxy tables are the way to go here. I'm assuming that they
will work across an ODBC connection. Anyone have other suggestions or
ideas? Should I be looking at replicatoin? If so, I know there are a
couple ways to approach that -- what is a good starting point?

Thanks!


Nick Elson Posted on 2006-06-23 13:54:37.0Z
From: "Nick Elson" <no_span_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <449b5a20$1@forums-1-dub>
Subject: Re: Proxy to 5.2? database
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
NNTP-Posting-Host: nicelson-m20.sybase.com
X-Original-NNTP-Posting-Host: nicelson-m20.sybase.com
Message-ID: <449bf29d$1@forums-1-dub>
Date: 23 Jun 2006 06:54:37 -0700
X-Trace: forums-1-dub 1151070877 10.25.98.215 (23 Jun 2006 06:54:37 -0700)
X-Original-Trace: 23 Jun 2006 06:54:37 -0700, nicelson-m20.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5463
Article PK: 1508

While proxy tables point to a local 5.5.05 server or one on the LAN
works, the 5.x ODBC driver and connectivity layer uses the UDP
protocol. UDP is not as viable as the TCP protocol across the internet
(or even any kind of WAN) and most corporate firewalls and routers
tend to block it entirely.

Depending upon how often 'occasional access' actually is (usage
tends to expand to exceed design) you may want to have a local
copy and find a way to synchronize those. SQL Remote or MobiLink
are options. So too might occasional backups.

"Steve Rhiner" <rhiner4022000_removethisbit@yahoo.com> wrote in message
news:449b5a20$1@forums-1-dub...
>I have an app on the drawing board that will need occaisonal data from a
>5.2
> (I think, maybe 5.1??) SQLA database. The app will primarily use a 9.0.2
> database. I was thinking to use proxy tables get data the old db to the
> new one.
>
> I don't think there will be a need to write to the old db. And I think
> amount of data transfered will be pretty small, and not particulary
> volatile.
>
> The two servers are about a million miles apart -- and communication
> between
> them will be across the internet. (They are actually only about 3 miles
> apart, but the point is that they are not in the same place.)
>
> I'm thinking proxy tables are the way to go here. I'm assuming that they
> will work across an ODBC connection. Anyone have other suggestions or
> ideas? Should I be looking at replicatoin? If so, I know there are a
> couple ways to approach that -- what is a good starting point?
>
> Thanks!
>
>


Breck Carter [Team iAnywhere] Posted on 2006-06-23 15:58:08.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Proxy to 5.2? database
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <t83o92h3b6cacs9r81ua88pk05qohmu8q8@4ax.com>
References: <449b5a20$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: host06.hourh.hyatthsiagx.com
X-Original-Trace: 23 Jun 2006 08:53:32 -0700, host06.hourh.hyatthsiagx.com
Lines: 47
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Jun 2006 08:53:35 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Jun 2006 08:58:08 -0700
X-Trace: forums-1-dub 1151078288 10.22.108.75 (23 Jun 2006 08:58:08 -0700)
X-Original-Trace: 23 Jun 2006 08:58:08 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5466
Article PK: 1512

Nick gives some interesting information about UDP versus TCP versus
firewalls... if that does cause you problems, then one (kludgy?)
possibility might be to install 9.0.2 on the same machine as the V5
database, and do the transfer in two hops: V5 to local V9 to
far-away-past-firewall V9. I have NOT TRIED that with proxy tables
(question: is it possible to define a V9 proxy table based on a proxy
table in another V9 database? possibly not)

Fill us in with some more details; e.g., frequency, number of rows or
bytes or whatever you know. Proxy tables are wondrous things, fun to
work with :)

Breck




On 22 Jun 2006 20:04:00 -0700, "Steve Rhiner"

<rhiner4022000_removethisbit@yahoo.com> wrote:

>I have an app on the drawing board that will need occaisonal data from a 5.2
>(I think, maybe 5.1??) SQLA database. The app will primarily use a 9.0.2
>database. I was thinking to use proxy tables get data the old db to the
>new one.
>
>I don't think there will be a need to write to the old db. And I think
>amount of data transfered will be pretty small, and not particulary
>volatile.
>
>The two servers are about a million miles apart -- and communication between
>them will be across the internet. (They are actually only about 3 miles
>apart, but the point is that they are not in the same place.)
>
>I'm thinking proxy tables are the way to go here. I'm assuming that they
>will work across an ODBC connection. Anyone have other suggestions or
>ideas? Should I be looking at replicatoin? If so, I know there are a
>couple ways to approach that -- what is a good starting point?
>
>Thanks!
>

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com