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.

Scripts to Upgrade ASA

2 posts in General Discussion Last posting was on 2002-09-25 14:27:38.0Z
Bill Posted on 2002-09-25 13:04:51.0Z
From: Bill
Date: Wed, 25 Sep 2002 09:04:51 -0400
Newsgroups: ianywhere.public.general
Subject: Scripts to Upgrade ASA
Message-ID: <EB0DC928F807F03B0047DAFB85256C3F.0047DB1B85256C3F@webforums>
Lines: 19
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:593
Article PK: 2412

Hello,

We have a few hundred users who currently have an ASA 5 database on their
laptops. We are going to use MobiLInk to synchronize data on these laptops.
To do so, we are going to upgrade each users database to ASA 8.0

In Sybase Central there is the "Unload Databse" feature for copying a DB
schema and data. Also when I connected to the 5.0 ASA DB from a 8.0 ML
server a wizard kicked off that walked me through a DB upgrade.

Here is my issue. The above mentioned procedures are fine for individual
databases, but we need to roll this out to hundreds of users.

Is there any standard process or upgrade scripts available to automate an
ASA DB upgrade? Is there any documentation or examples of this? This seems
like an issue that would come up fairly often.

Thanks,
Bill


Robert Waywell Posted on 2002-09-25 14:27:38.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <EB0DC928F807F03B0047DAFB85256C3F.0047DB1B85256C3F@webforums>
Subject: Re: Scripts to Upgrade ASA
Date: Wed, 25 Sep 2002 10:27:38 -0400
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <bztUvGKZCHA.313@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:592
Article PK: 2407

Take a look at the dbunload utility and the -an switch. It should give you
the functionality that you need.

You may want to post any follow up questions to the
sybase.public.sqlanywhere.general newsgroup which is more specifically
focused on ASA.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Bill> wrote in message
news:EB0DC928F807F03B0047DAFB85256C3F.0047DB1B85256C3F@webforums...
> Hello,
>
> We have a few hundred users who currently have an ASA 5 database on their
> laptops. We are going to use MobiLInk to synchronize data on these
laptops.
> To do so, we are going to upgrade each users database to ASA 8.0
>
> In Sybase Central there is the "Unload Databse" feature for copying a DB
> schema and data. Also when I connected to the 5.0 ASA DB from a 8.0 ML
> server a wizard kicked off that walked me through a DB upgrade.
>
> Here is my issue. The above mentioned procedures are fine for individual
> databases, but we need to roll this out to hundreds of users.
>
> Is there any standard process or upgrade scripts available to automate an
> ASA DB upgrade? Is there any documentation or examples of this? This seems
> like an issue that would come up fairly often.
>
> Thanks,
> Bill