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.

SQLAnywhere Studio capabilities questions

3 posts in General Discussion Last posting was on 2004-02-02 19:20:22.0Z
Andy Cohan Posted on 2004-01-29 19:55:46.0Z
Sender: 6581.4019654e.1804289383@sybase.com
From: Andy Cohan
Newsgroups: ianywhere.public.general
Subject: SQLAnywhere Studio capabilities questions
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <401967a3.65b3.846930886@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 29 Jan 2004 12:05:55 -0800, 10.22.241.42
Lines: 24
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Jan 2004 11:39:04 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Jan 2004 11:55:46 -0800
X-Trace: forums-1-dub 1075406146 10.22.108.75 (29 Jan 2004 11:55:46 -0800)
X-Original-Trace: 29 Jan 2004 11:55:46 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2406
Article PK: 5546

I have a client using a 3rd-party order management/billing,
etc. application based on SQLAnywhere Studio 7.04,
apparently migrating to v9 in the not-too-distant future.

I would like synchronize all changes to that "core" database
to a new one that I could write my own queries against, and
create new tables along with applications that read/write
those new tables. Effectively, I want to extend the
functionality of the product by using a one-way synchronized
copy of the original database that I then augment to manage
the additional data and processing my client requires.

1) is that going to be easy or hard? what products/licenses
would I need to buy and about what would that cost?

2) can it be done to load up a SQL Server database instead?
a MySQL database? is that harder and/or more expensive?

If you need more information in order to answer, please let
me know.

TIA,

AFC


Nick Elson Posted on 2004-01-30 22:09:31.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <401967a3.65b3.846930886@sybase.com>
Subject: Re: SQLAnywhere Studio capabilities questions
Lines: 55
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: nicelson-xp.sybase.com
X-Original-NNTP-Posting-Host: nicelson-xp.sybase.com
Message-ID: <401ad61b$1@forums-1-dub>
Date: 30 Jan 2004 14:09:31 -0800
X-Trace: forums-1-dub 1075500571 172.31.143.54 (30 Jan 2004 14:09:31 -0800)
X-Original-Trace: 30 Jan 2004 14:09:31 -0800, nicelson-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2414
Article PK: 5554

At the highest level you may be able to do this with either
SQL Remote or MobiLink technologies.

Definitely check with **sales** on additional server
pricing and licensing requirements.

You will want to consult with your 3rd-party vendor since
they would be in a much better position to advice on
their schema and probably how much work would be
involved.

Nothing you have said indicates that this would be all that
difficult to set up but you do have to do some designing
and planning. If you are not up for that part yourself then
you may want to ask your vendor or some local consultant
to help.

To investigate these technologies further, there are tutorials
available in the on-line manuals and even a SQL Remote
techdoc. [http://www.sybase.com/detail?id=44605]
that may help you decide how difficult this would be for
you to try to do it yourself.

If you don't have the full package the eval. copy has
most of everything you need to research and test this
out a bit more.

<Andy Cohan> wrote in message news:401967a3.65b3.846930886@sybase.com...
> I have a client using a 3rd-party order management/billing,
> etc. application based on SQLAnywhere Studio 7.04,
> apparently migrating to v9 in the not-too-distant future.
>
> I would like synchronize all changes to that "core" database
> to a new one that I could write my own queries against, and
> create new tables along with applications that read/write
> those new tables. Effectively, I want to extend the
> functionality of the product by using a one-way synchronized
> copy of the original database that I then augment to manage
> the additional data and processing my client requires.
>
> 1) is that going to be easy or hard? what products/licenses
> would I need to buy and about what would that cost?
>
> 2) can it be done to load up a SQL Server database instead?
> a MySQL database? is that harder and/or more expensive?
>
> If you need more information in order to answer, please let
> me know.
>
> TIA,
>
> AFC


Andy Cohan Posted on 2004-02-02 19:20:22.0Z
Sender: 2a99.401ea4b0.1804289383@sybase.com
From: Andy Cohan
Newsgroups: ianywhere.public.general
Subject: Re: SQLAnywhere Studio capabilities questions
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <401ea565.2aa1.846930886@sybase.com>
References: <401967a3.65b3.846930886@sybase.com><401ad61b$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 2 Feb 2004 11:30:45 -0800, 10.22.241.42
Lines: 59
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 Feb 2004 11:03:17 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 Feb 2004 11:20:22 -0800
X-Trace: forums-1-dub 1075749622 10.22.108.75 (2 Feb 2004 11:20:22 -0800)
X-Original-Trace: 2 Feb 2004 11:20:22 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2417
Article PK: 5557

Thank you very much; I appreciate the response.

AFC

> At the highest level you may be able to do this with
> either SQL Remote or MobiLink technologies.
>
> Definitely check with **sales** on additional server
> pricing and licensing requirements.
>
> You will want to consult with your 3rd-party vendor since
> they would be in a much better position to advice on
> their schema and probably how much work would be
> involved.
>
> Nothing you have said indicates that this would be all
> that difficult to set up but you do have to do some
> designing and planning. If you are not up for that part
> yourself then you may want to ask your vendor or some
> local consultant to help.
>
> To investigate these technologies further, there are
> tutorials available in the on-line manuals and even a SQL
> Remote techdoc. [http://www.sybase.com/detail?id=44605]
> that may help you decide how difficult this would be for
> you to try to do it yourself.
>
> If you don't have the full package the eval. copy has
> most of everything you need to research and test this
> out a bit more.
>
>
> <Andy Cohan> wrote in message
> > news:401967a3.65b3.846930886@sybase.com... I have a
> > client using a 3rd-party order management/billing, etc.
> > application based on SQLAnywhere Studio 7.04, apparently
> migrating to v9 in the not-too-distant future. >
> > I would like synchronize all changes to that "core"
> > database to a new one that I could write my own queries
> > against, and create new tables along with applications
> > that read/write those new tables. Effectively, I want
> > to extend the functionality of the product by using a
> > one-way synchronized copy of the original database that
> > I then augment to manage the additional data and
> processing my client requires. >
> > 1) is that going to be easy or hard? what
> > products/licenses would I need to buy and about what
> would that cost? >
> > 2) can it be done to load up a SQL Server database
> > instead? a MySQL database? is that harder and/or more
> expensive? >
> > If you need more information in order to answer, please
> > let me know.
> >
> > TIA,
> >
> > AFC
>
>