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.

How to transform a sybase 5.5 database into a Sybase 9.0 ?

6 posts in General Discussion Last posting was on 2006-01-26 16:22:09.0Z
Fenix Posted on 2006-01-25 04:30:30.0Z
From: "Fenix" <NOTHING@EMAIL.COM>
Newsgroups: ianywhere.public.general
Subject: How to transform a sybase 5.5 database into a Sybase 9.0 ?
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: 210.17.250.95
Message-ID: <43d6fbc2@forums-2-dub>
X-Original-Trace: 24 Jan 2006 20:17:06 -0800, 210.17.250.95
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Jan 2006 20:17:08 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Jan 2006 20:30:30 -0800
X-Trace: forums-1-dub 1138163430 10.22.108.75 (24 Jan 2006 20:30:30 -0800)
X-Original-Trace: 24 Jan 2006 20:30:30 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5144
Article PK: 1207

Good day.



I have a Sybase 5.5 database, and I want to transform the data into a Sybase
9.0 format. But I don¡¦t know how to do it, and what would cause the data
lost in the transformation.



Could anybody tell me how to solve this problem?



Thank you,

Fenix


"Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g Posted on 2006-01-25 04:44:06.0Z
From: "Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: How to transform a sybase 5.5 database into a Sybase 9.0 ?
References: <43d6fbc2@forums-2-dub>
In-Reply-To: <43d6fbc2@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 10.18.242.14
Message-ID: <43d6fef2@forums-2-dub>
X-Original-Trace: 24 Jan 2006 20:30:42 -0800, 10.18.242.14
Lines: 28
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Jan 2006 20:30:44 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Jan 2006 20:44:06 -0800
X-Trace: forums-1-dub 1138164246 10.22.108.75 (24 Jan 2006 20:44:06 -0800)
X-Original-Trace: 24 Jan 2006 20:44:06 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5145
Article PK: 1210

An unload/reload using ASA9 tools will do this for you. You can use the
rebuild batch that is provided or dbunload. The documentation also
provides information on this process.

When you indicate 'lost' data, what exactly do you mean?
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Fenix Posted on 2006-01-25 05:26:51.0Z
From: "Fenix" <NOTHING@EMAIL.COM>
Newsgroups: ianywhere.public.general
References: <43d6fbc2@forums-2-dub> <43d6fef2@forums-2-dub>
Subject: Re: How to transform a sybase 5.5 database into a Sybase 9.0 ?
Lines: 65
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: 210.17.250.95
Message-ID: <43d708f9$1@forums-2-dub>
X-Original-Trace: 24 Jan 2006 21:13:29 -0800, 210.17.250.95
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Jan 2006 21:13:31 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Jan 2006 21:26:51 -0800
X-Trace: forums-1-dub 1138166811 10.22.108.75 (24 Jan 2006 21:26:51 -0800)
X-Original-Trace: 24 Jan 2006 21:26:51 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5146
Article PK: 1209

Thank you for answering the question.



Now I am looking the web page: "Deploying the Adaptive Server Anywhere 9.0.0
Administration Tools Without InstallShield". I think that is the "ASA9
toolz" what you means.



http://eshop.sybase.com/detail/1,6904,1027674,00.html



The "data lost" is just my imagination --- If the solution is provided by
Sybase, I don't believe it would cause data lost in the transformation. So
forget it. (^_^!)



Again, thank you for your answer (^o^)



Fenix.

"Chris Keating(iAnywhere Solutions)"

<NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com> wrote in message
news:43d6fef2@forums-2-dub...
> An unload/reload using ASA9 tools will do this for you. You can use the
> rebuild batch that is provided or dbunload. The documentation also
> provides information on this process.
>
> When you indicate 'lost' data, what exactly do you mean?
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
>

****************************************************************************
*
> Sign up today for your copy of the SQL Anywhere Studio 9 Developer
> Edition =and try out the market-leading database for mobile, embedded
> and small to medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
>
****************************************************************************
*
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use Case Express to report bugs http://case-express.sybase.com
>
>
****************************************************************************
*


"Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g Posted on 2006-01-25 13:23:06.0Z
From: "Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: How to transform a sybase 5.5 database into a Sybase 9.0 ?
References: <43d6fbc2@forums-2-dub> <43d6fef2@forums-2-dub> <43d708f9$1@forums-2-dub>
In-Reply-To: <43d708f9$1@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <43d77bba@forums-1-dub>
Date: 25 Jan 2006 05:23:06 -0800
X-Trace: forums-1-dub 1138195386 10.25.98.170 (25 Jan 2006 05:23:06 -0800)
X-Original-Trace: 25 Jan 2006 05:23:06 -0800, keating-dm20.sybase.com
Lines: 26
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5148
Article PK: 1212

These are not the tools I mean. What I meant was that you should use the
ASA9 dbunload (or equivalent ASA9 functionality i.e., Sybase Central,API
calls) to perform the rebuild of that database.
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Fenix Posted on 2006-01-26 03:31:26.0Z
From: "Fenix" <NOTHING@EMAIL.COM>
Newsgroups: ianywhere.public.general
References: <43d6fbc2@forums-2-dub> <43d6fef2@forums-2-dub> <43d708f9$1@forums-2-dub> <43d77bba@forums-1-dub>
Subject: Re: How to transform a sybase 5.5 database into a Sybase 9.0 ?
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: 210.17.250.95
Message-ID: <43d83f63@forums-2-dub>
X-Original-Trace: 25 Jan 2006 19:17:55 -0800, 210.17.250.95
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Jan 2006 19:17:58 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Jan 2006 19:31:26 -0800
X-Trace: forums-1-dub 1138246286 10.22.108.75 (25 Jan 2006 19:31:26 -0800)
X-Original-Trace: 25 Jan 2006 19:31:26 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5152
Article PK: 1215

(>_<!) Sorry, I think I misunderstand your meaning.



It was because I don't use the Sybase database before. But my boss asked me
to search about the method for transform Sybase 5.5 to Sybase 9.0 database.
So I don't really understand what "ASA 9 Dbunload" is.



Is that "ASA 9 DBunload" means "Adaptive Server Anywhere Database Unloading
and Reloading."?



"Chris Keating(iAnywhere Solutions)"

<NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com> wrote in message
news:43d77bba@forums-1-dub...
> These are not the tools I mean. What I meant was that you should use the
> ASA9 dbunload (or equivalent ASA9 functionality i.e., Sybase Central,API
> calls) to perform the rebuild of that database.
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
>

****************************************************************************
*
> Sign up today for your copy of the SQL Anywhere Studio 9 Developer
> Edition =and try out the market-leading database for mobile, embedded
> and small to medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
>
****************************************************************************
*
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use Case Express to report bugs http://case-express.sybase.com
>
>
****************************************************************************
*


"Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g Posted on 2006-01-26 16:22:09.0Z
From: "Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: How to transform a sybase 5.5 database into a Sybase 9.0 ?
References: <43d6fbc2@forums-2-dub> <43d6fef2@forums-2-dub> <43d708f9$1@forums-2-dub> <43d77bba@forums-1-dub> <43d83f63@forums-2-dub>
In-Reply-To: <43d83f63@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <43d8f731$1@forums-1-dub>
Date: 26 Jan 2006 08:22:09 -0800
X-Trace: forums-1-dub 1138292529 10.25.98.170 (26 Jan 2006 08:22:09 -0800)
X-Original-Trace: 26 Jan 2006 08:22:09 -0800, keating-dm20.sybase.com
Lines: 25
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5153
Article PK: 1216

Yes that would be the topic. Also, you can look at rebuild.bat and
dbunload.exe.
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************