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.

Download Database from ASE 11.9.2 to ASE 11.0.2 ?

4 posts in Windows NT Last posting was on 2000-06-21 17:58:30.0Z
teresa young Posted on 2000-06-21 10:15:52.0Z
Message-ID: <395095D8.394934F5@qware.net>
Date: Wed, 21 Jun 2000 18:15:52 +0800
From: Teresa Young <teresa@qware.net>
X-Mailer: Mozilla 4.5 [zhtw]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Download Database from ASE 11.9.2 to ASE 11.0.2 ?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 13
NNTP-Posting-Host: 210.209.57.34
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1989
Article PK: 1089438

Dear All:
We have a Sybase ASE11.9.2 on Window NT, and we already run some
application on it about 6 months. Since the third party software we use
cann't support ASE11.9.2, we must use ASE 11.0.2. Can we just backup the
database of ASE11.9.2 then restore the backup database to ASE11.0.2 ?
Has it any problem ? Or, We must do following procedure.
1) bcp out the data from ASE11.9.2
2) create the database on ASE11.0.2
3) bcp in the 1) data to ASE11.0.2
Can anyone tell me??

Teresa Young


Tommy Phillips Posted on 2000-06-21 17:58:30.0Z
Message-ID: <39510246.9E49D973@sybase.com>
Date: Wed, 21 Jun 2000 11:58:30 -0600
From: Tommy Phillips <tommy@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.73 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Download Database from ASE 11.9.2 to ASE 11.0.2 ?
References: <395095D8.394934F5@qware.net>
Content-Type: multipart/mixed; boundary="------------E934176714DFAF5E19745575"
Newsgroups: sybase.public.sqlserver.nt
Lines: 37
NNTP-Posting-Host: tommy-lpt.sybase.com 157.133.56.58
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1981
Article PK: 1089425

Or, since you have 11.9.2, you could set up proxy tables pointing to the 11.0.2 tables, then insert ... select to move the data.

Teresa Young wrote:
>
> Dear All:
> We have a Sybase ASE11.9.2 on Window NT, and we already run some
> application on it about 6 months. Since the third party software we use
> cann't support ASE11.9.2, we must use ASE 11.0.2. Can we just backup the
> database of ASE11.9.2 then restore the backup database to ASE11.0.2 ?
> Has it any problem ? Or, We must do following procedure.
> 1) bcp out the data from ASE11.9.2
> 2) create the database on ASE11.0.2
> 3) bcp in the 1) data to ASE11.0.2
> Can anyone tell me??
>
> Teresa Young


Download VCard tommy.vcf


Eric McGrane Posted on 2000-06-21 12:17:11.0Z
Message-ID: <3950B247.7B6FA577@sybase.com>
Date: Wed, 21 Jun 2000 08:17:11 -0400
From: Eric McGrane <mcgrane@sybase.com>
X-Mailer: Mozilla 4.7 [en] (Win95; U)
X-Accept-Language: en
MIME-Version: 1.0
To: Teresa Young <teresa@qware.net>
Subject: Re: Download Database from ASE 11.9.2 to ASE 11.0.2 ?
References: <395095D8.394934F5@qware.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 23
NNTP-Posting-Host: 158.159.8.38
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1988
Article PK: 1089436

Teresa,

The problem with dump and load is that the log format in 11.9.2 is much
different than it was in 11.0.2 so a load will not work. You will need to
bcp out the data and bcp it back in.

There are other issues in that 11.9.2 has some system tables that 11.0.x
doesn't have, but the biggest issue is the log format.

E

Teresa Young wrote:

> Dear All:
> We have a Sybase ASE11.9.2 on Window NT, and we already run some
> application on it about 6 months. Since the third party software we use
> cann't support ASE11.9.2, we must use ASE 11.0.2. Can we just backup the
> database of ASE11.9.2 then restore the backup database to ASE11.0.2 ?
> Has it any problem ? Or, We must do following procedure.
> 1) bcp out the data from ASE11.9.2
> 2) create the database on ASE11.0.2
> 3) bcp in the 1) data to ASE11.0.2
> Can anyone tell me??
>
> Teresa Young


Jason Froebe Posted on 2000-06-21 14:09:24.0Z
From: "Jason Froebe" <jfroebe@sybase.com>
References: <395095D8.394934F5@qware.net> <3950B247.7B6FA577@sybase.com>
Subject: Re: Download Database from ASE 11.9.2 to ASE 11.0.2 ?
Date: Wed, 21 Jun 2000 09:09:24 -0500
Lines: 39
Organization: Sybase, Inc.
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-Mimeole: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <nWuBou42$GA.204@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 158.159.8.63
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1985
Article PK: 1089430

Hi Teresa,

You should be able to use SQL Remote (included with ASE 11.9.2) to transfer
the data. Note that SQL Remote is a light weight replication utility.
Heavy duty replication should only be performed with Sybase's Replication
Server.

j

"Eric McGrane" <mcgrane@sybase.com> wrote in message
news:3950B247.7B6FA577@sybase.com...
> Teresa,
>
> The problem with dump and load is that the log format in 11.9.2 is much
> different than it was in 11.0.2 so a load will not work. You will need to
> bcp out the data and bcp it back in.
>
> There are other issues in that 11.9.2 has some system tables that 11.0.x
> doesn't have, but the biggest issue is the log format.
>
> E
>
> Teresa Young wrote:
>
> > Dear All:
> > We have a Sybase ASE11.9.2 on Window NT, and we already run some
> > application on it about 6 months. Since the third party software we use
> > cann't support ASE11.9.2, we must use ASE 11.0.2. Can we just backup the
> > database of ASE11.9.2 then restore the backup database to ASE11.0.2 ?
> > Has it any problem ? Or, We must do following procedure.
> > 1) bcp out the data from ASE11.9.2
> > 2) create the database on ASE11.0.2
> > 3) bcp in the 1) data to ASE11.0.2
> > Can anyone tell me??
> >
> > Teresa Young
>