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.

Upgrading SQL Anywhere 5 to ASE 12

3 posts in General Discussion Last posting was on 2003-02-10 22:44:51.0Z
ejaqua Posted on 2003-02-06 23:23:49.0Z
From: ejaqua
Date: Thu, 6 Feb 2003 18:23:49 -0500
Newsgroups: ianywhere.public.general
Subject: Upgrading SQL Anywhere 5 to ASE 12
Message-ID: <60D695BC8BF0659A008085EC85256CC5.008085FB85256CC5@webforums>
Lines: 6
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:171
Article PK: 1995

Is there any easy way to migrate my SQL Anywhere 5.5 databases to ASE 12.5.
I think I can BCP/export the data out of SQL Anywhere and BCP it into ASE,
but I'd have to create the database and all the tables via a script, etc.
Whatever will help this process would be appreciated.

Edwin Jaqua


Chris Keating Posted on 2003-02-07 00:51:04.0Z
From: "Chris Keating" <Spam_Free_keating@iAnywhere.com>
References: <60D695BC8BF0659A008085EC85256CC5.008085FB85256CC5@webforums>
Subject: Re: Upgrading SQL Anywhere 5 to ASE 12
Date: Thu, 6 Feb 2003 19:51:04 -0500
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <a4niyWkzCHA.362@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 158.159.8.58
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:170
Article PK: 1993

You could use PowerDesigner to reverse engineer the database.

<ejaqua> wrote in message
news:60D695BC8BF0659A008085EC85256CC5.008085FB85256CC5@webforums...
> Is there any easy way to migrate my SQL Anywhere 5.5 databases to ASE
12.5.
> I think I can BCP/export the data out of SQL Anywhere and BCP it into
ASE,
> but I'd have to create the database and all the tables via a script, etc.
> Whatever will help this process would be appreciated.
>
> Edwin Jaqua


ejaqua Posted on 2003-02-10 22:44:51.0Z
From: ejaqua
Date: Mon, 10 Feb 2003 17:44:51 -0500
Newsgroups: ianywhere.public.general
Subject: Re: Upgrading SQL Anywhere 5 to ASE 12
Message-ID: <73FFE9BFB1A041D1007CF4A085256CC9.000A697C85256CC6@webforums>
References: <60D695BC8BF0659A008085EC85256CC5.008085FB85256CC5@webforums> <a4niyWkzCHA.362@forums.sybase.com>
Lines: 3
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:153
Article PK: 1977

Thanks! I'll give it a try.

Edwin