Download Database from ASE 11.9.2 to ASE 11.0.2 ?

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

0
Teresa
6/21/2000 10:15:52 AM
sybase.sqlserver.nt 2169 articles. 0 followers. Follow

3 Replies
1390 Views

Similar Articles

[PageSpeed] 21
Get it on Google Play
Get it on Apple App Store

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

0
Eric
6/21/2000 12:17:11 PM
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
>


0
Jason
6/21/2000 2:09:24 PM
This is a multi-part message in MIME format.
--------------E934176714DFAF5E19745575
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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
--------------E934176714DFAF5E19745575
Content-Type: text/x-vcard; charset=us-ascii;
 name="tommy.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Tommy Phillips
Content-Disposition: attachment;
 filename="tommy.vcf"

begin:vcard 
n:Phillips;Tommy
tel;pager:888-661-6322 (6616322@skytel.com for text)
tel;work:303-486-7720
x-mozilla-html:FALSE
org:Sybase Professional Services
adr:;;8400 E Crescent Pkwy Suite 400;Englewood;CO;80111;USA
version:2.1
email;internet:tommy@sybase.com
title:Principal Consultant
end:vcard

--------------E934176714DFAF5E19745575--

0
Tommy
6/21/2000 5:58:30 PM
Reply:

Similar Artilces:

Can we restore a database on ASE 11.0.3 which was on ASE 11.0.2 ?
Hi, I did a backup of a database which was on ASE 11.0.2. Can we restore it without any problems on ASE 11.0.3 ? Thanks very much. -- Have a nice day. Raphael Lignier Escalation Support Engineer ASCEND COMMUNICATIONS GIS - Sophia-Antipolis On Wed, 31 Mar 1999 15:02:30 -0800, Raphael Lignier <rlignier@ascend.com> wrote: >Hi, > >I did a backup of a database which was on ASE 11.0.2. > >Can we restore it without any problems on ASE 11.0.3 ? Yes, dumps are upward compatible (that is: you can load older dumps on newer servers). When conversion...

SQLRemote Problem with 7.0.2-1 and 6.0.2-1 on Linux [ASE 11.9.2-3 and ASE 12.5 eval]
Hi all I got the following problems using sql-remote. on ASE 12.5 eval: I got the following RPMs installed on RedHat Linux 7.2 - Kernel 2.4.17 - glibc-2.2.4 sybase-ase-12.5-3.i386.rpm sybase-common-12.5-3.i386.rpm sybase-openclient-12.5-3.i386.rpm sybase-sqlremote-7.0.2-1.i386.rpm After the execution of ssxtract or ssremote I got an error like: ../ssxtract: /opt/sybase-12.5/SQLRemote/lib/libsstasks7_r.so: version `libdbtasks7_r.so' not found (required by ./ssxtract) The file libsstasks7_r.so exists and the path is correctly specified in /etc/ld.so.conf. There'...

replicate ASE 11.0.3 via R.S. 11.5 to ASE 11.9.2
Has any one successfully replicated from 11.0.3 using Rep Server 11.5 to ASE 11.9.2 using ltm's? We are running on solaris 2.6 using veritas filesystem and keep getting stack traces (this shuts down the connection). I would like to know if anyone else has replicated using these versions or something similar. Thanks. kboniface@worldres.com Yes, I have done this. No specific problems. HTH, Rob -- ---------------------------------------------------------------------- Rob Verschoor Certified Sybase ASE 11.5 Administrator (Professional) Certified DBA/Performance...

Upgrade from 11.0.3.2 to ASE 11.9.2
I've seen different postings claiming that 11.0.3 can directly upgrade to 11.9.2. However, the release bulletin for Sybase ASE 11.9.2 (Doc ID = 72410-01-1192-02) says that "You can upgrade 11.9.2 only from 10.0.2.7, 11.0.3.3, 11.5 and later). We are currently using 11.0.3.2. Does it mean that I will have to upgrade our server to 11.0.3.3 (from 11.0.3.2) before I can migrate to ASE 11.9.2? I will appreciate if someone clarify this. Thanks. CGS tcgs@hotmail.com CGS wrote: > > I've seen different postings claiming that 11.0.3 can directly upgrade...

Transferring database ASE 11.9.2 -> ASE 11.5
Hello, I need to transfer a database from a ASE 11.9.2 server to a ASE 11.5 server. (Servers have the same specs and run Windows NT 4.0). The database doesn't have many objects such as tables, users, Views, SP's etc. etc. It has a 400 MB device for data and 100 MB Device for the log, with standard segmentation. It's relatively small. I understand from this newsgroup that dumping on a newer release and loading on an older release is not an option. Now I figure I have to do the following: - Create a data and a log device with similar names and sizes on the ASE 11.5 se...

Can I have 11.0.2 and ASE 11.9.2 running on the same machine?
Hi, I have server with Sybase 11.0.2 installed on it for testing. Now I need to install on the same machine ASE 11.9.2 also for testing. I really would like to keep both versions running on the same server and I'm thinking about whole installation of ASE 11.9.2 just on another hard drive from Sybase 11.0.2. Is it possible? Or I have to save my backups, uninstall 11.0.2, install whole new 11.9.2 and restore from backups? Thank you Ninel You could do it provided you are able to specify a port number different from what 11.0.2 is using. Anil Ninel Roytman wrote: &g...

ASE 11.0.3.3 and ASE 11.9.2 on same box
Hi evereyone, I would like to install 2 ASE servers with different versions on same linux box. Is this possible? Here is what I tried to do: I have a working ASE 11.9.2 on linux box tried to install ASE 11.0.3.3 on same box in different directory and it gave me an error. Wondering if this ispossible at all. Appreciate any help. TIA ar The 11.0.3.3 rpm tries to uninstall the 11.9.2 package. I shutdown the 11.9.2 server before install 11.0.3.3 and I do not keep the both versions running. The variables SYBASE, LD_LIBRARY_PATH ,PATH must be correctly set to point the...

NT Appication Problem When Upgrading ASE 11.0.3 to 11.9.2
Hi We have recently upgraded from ASE 11.0.3 to ASE 11.9.2 on HP-UX 10.20. We are using Sybase 11 ODBC 3.11.00.01 on NT 4.0. And we are using libxxx.dll from Sybase 11. Below is the problem which we are unable to solve: We have a 3rd Party application which was build using VC++, Sybase O/C and ODBC. Since it is 3rd party application I don't know which version of Sybase O/C they used for the build. This application is working fine on ASE 11.0.3, but not working with ASE 11.9.2. Unfortunately one of the important screen of the application is not working and it has only ...

convert float to char (ASE 11.9.2 , ASE 11.9.3)
declare @n float select @n = 12.001 select convert(varchar(20), @n) go isql returned -------------------- 12.000999999999999 Why? MS SQL 6.5 returns 12.001 Thanks Ivan Rubinov This is a multi-part message in MIME format. --------------B8833FC9B364722D034F7974 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit First, when converting from an imprecise numeric (FLOAT, REAL) you should be using the str() function, rather than convert. The floating point datatype cannot store 12.001 exactly. The convert is displaying the value that is ...

Problem in Installating Monitor Server 11.9.2 on ASE 11.9.2.
Hi, I was tryint to install SQL monitor server 11.9.2 on ASE 11.9.2 on HP-UX 11.0 9000/800. It gives the following error """""""""""""""""""""""" Nov 14 12:28:18 2000: DB-Library Version: Nov 14 12:28:18 2000: Sybase DB-Library/11.1.1/P-EBF8022/hp800/HP-UX 10.01/1/OPT/Fri Jun 26 15:04:39 1998 Nov 14 12:28:18 2000: Open Server Version: Nov 14 12:28:18 2000: Sybase Server-Library/11.1.1/P-EBF8022/hp800/HP-UX 10.01/1/OPT/Fri Jun 26 13:53:53 1998 Nov 14 12:2...

Problems in reverse engineering an ASA 6.0.2 database to build and ASE 11.9.2 schema
I am in the process of migrating our database backend from ASA 6.0.2 to ASE 11.9.2. I have PD AppModeler 6.1.4.790 32-bit which I have used to reverse-engineer the current ASA database tables and stored procedures. I then changed my 'target' database to ASE 11.5-11.9 and generated the table schemas and stored procedure creation scripts for loading into ASE. Although the create table scripts had some minor issues (i.e. generating 'on default' instead of on 'default') the stored procedures scripts failed miserably. Functions available in ASA are no longer support...

Cannot drop foreign key constraint in ASE 11.9.2
Hi I need to drop foreign key constraint and drop referenced table, then create another table-parent to be referenced . The problem is that it doesn't allow to drop table because of FKey constraint. When I try to drop the FKey constraint - it doesn't allow this and doesn't give an error message. This problem I experience on production server and this should be fixed urgently but seems like nothing I've tried helps to solve it. I'm using ASE 11.9.2 on NT4.0. If anybody has some ideas it would be very appreciated. Thank you. Ninel <<<< I need to drop ...

Upgrade 11.0.3.3 to ASE 11.9.2 with RepServer 11.5 and LTMs
I am preparing to upgrade our production servers (11.0.3.3) using RepServer 11.5 with LTMs. My understanding is that the ASE 11.9.2 has RepAgents build in as Open Server applications. Are there any issues with upgrading that I need to be aware of? Where would I look? I would assume that I don't need to run LTMs anymore, but I need to ensure no loss of replication to the warm standby. Any advice? Take care. JCS ASE 11.5+ has RepAgent built in as internal server threads (which has nothing to do with OpenServer). When upgrading, keep the LTM's and upgrade to RS 11.5 / ...

loading an ASE 12 database on ASE 11.9.2 ?
I've this dump of a database, dumped from an ASE 12 system. I now want to load that on on to an ASE 11.9.2 system. Is this possible and how? It would really make my replication ASE 12 -> ASE 11.9.2 easier... /T Hi, IMHO there is no work around to loading a higher version onto a lower one! Tobbe wrote: I've this dump of a database, dumped from an ASE 12 system. I now want to load that on on to an ASE 11.9.2 system. Is this possible and how? It would really make my replication ASE 12 -> ASE 11.9.2 easier... /T ...

Web resources about - Download Database from ASE 11.9.2 to ASE 11.0.2 ? - sybase.sqlserver.nt

Don't Download This Song - Wikipedia, the free encyclopedia
" Don't Download This Song " is the first single from "Weird Al" Yankovic 's 12th studio album Straight Outta Lynwood . The song was released ...

Facebook Adds To Download Your Information
Facebook increased the amount of information users can access when they download their account histories using the social network’s Download ...

Download the Facebook IQ digital magazine - Facebook for Business
The Facebook IQ digital magazine puts all the insights, best practices and key stats in one place. Download it on your mobile and read it anywhere. ...

Downloads
Download previous versions of the Facebook for iOS SDK.

‘Silent updates’ for Android download latest version of Facebook without Google Play
... users to receive app updates without going through the Google Play store. Some Android users are now receiving “silent updates,” which download ...

Lifehacker, tips and downloads for getting things done
Lifehacker curates tips, tricks, and technology for living better in the digital age.

Technology Product Reviews, News, Prices & Downloads - PCMag.com - PC Magazine
PC Magazine is your complete guide to PC computers, peripherals and upgrades. We test and review computer- and Internet-related products and ...

Indie Music News, MP3 Downloads, Music Videos, Reviews - Stereogum
MP3s downloads, music videos, concert reviews, tour dates and contests. Updated regularly.

RN Download ThisShow (@RNDownload) on Twitter
Log in Sign up You are on Twitter Mobile because you are using an old version of Internet Explorer. Learn more here RN Download ThisShow @ RNDownload ...

Boston Download: Hate Crime at Harvard, Airline Finds Marathon Survivor's Prosthetic Leg
Harvard Law Faculty Portraits Defaced in Racially Motivated Vandalism Someone put black tape over the faces of black law professors in portraits ...

Resources last updated: 12/3/2015 12:13:39 PM