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.

Migration to ASE 12 from ASE 11.5

3 posts in Windows NT Last posting was on 2000-10-31 21:03:48.0Z
Puvendran Selvaratnam Posted on 2000-02-04 01:57:11.0Z
From: "Puvendran Selvaratnam" <puvendran.selvaratnam@btfinancialgroup.com>
Subject: Migration to ASE 12 from ASE 11.5
Date: Fri, 4 Feb 2000 12:57:11 +1100
Lines: 20
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <gX7jsOrb$GA.184@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: aupozx665.btal.com.au 203.10.111.3
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2587
Article PK: 1090039

Hi all,

Has anyone out there perormed a migration from ASE 11.5.1.1 to ASE 12 on NT.
If so I would be greatful if you could provide information on the following

1. Ease of migration and any issues encountered.

2. Sizes of databases migrated

3. Adopted migration plans - I could not find anything on the Sybase web
site.

4. Experiences on ASE 12.

Thanking you in advance

Puvendran


Andy Price Posted on 2000-02-07 17:18:16.0Z
From: "Andy Price" <andy.price@canada.com>
References: <gX7jsOrb$GA.184@forums.sybase.com>
Subject: Re: Migration to ASE 12 from ASE 11.5
Date: Mon, 7 Feb 2000 18:18:16 +0100
Keywords: sybase, ase, v12
Lines: 79
Organization: MCL
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <AkK3c$Yc$GA.223@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 213.167.0.3
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2573
Article PK: 1090023

Hi,

Yes, I have performed a migration from both v11.5.1 to v12 and from
v11.9.2.1 to 12. I have put my responses below each of your questions.

--
Andy Price,
Sybase Certified Adaptive Server DBA v11.5
email: andy.price@canada.com

Puvendran Selvaratnam <puvendran.selvaratnam@btfinancialgroup.com> wrote in
message news:gX7jsOrb$GA.184@forums.sybase.com...
> Hi all,
>
> Has anyone out there perormed a migration from ASE 11.5.1.1 to ASE 12 on
NT.
> If so I would be greatful if you could provide information on the
following
>
> 1. Ease of migration and any issues encountered.

Firstly, I recommend not performing an upgrade, but remove the v11.5 of
Sybase and then reinstall the v12 binaries. Make sure you go through the
registry manually before reinstalling v12 on NT as Sybase's uninstaller
leaves a lot of entries behind.

The migration is simple and i encountered no problems as such, though you
need to be aware that syslogins has an additional column in v12 (logincount
smallint). When I create a new server (v11.x), I always bcp out syslogins
and sysloginroles so that all databases when they are loaded have the user's
mapped to their correct suid in syslogins and it keeps their passwords in
v11.x servers. In v12, the passwords do not work if you perform a bcp in of
syslogins so you'll have to update these if you adopt this approach. An
alternative to bcp in of syslogins and sysloginroles is to reverse-engineer
the sp_addlogin and sp_adduser/sp_addalias commands IN THE CORRECT ORDER. I
recommend this for migrating to v12. If you have a user's table containing
their unencrypted passwords, you can use that to recreate their logins
properly. If not, it's a case of setting it to something people should
change immediately. If you have triggers, you will need to update statistics
in those databases or they won't fire (this happened in v11.9.2). It is a
good idea to do this anyway.

nothing else of note, just make sure you have time to read up on the new
features and changes to the optimiser. test your main queries to ensure they
run at least as fast. benchmark your back-up procedures.


>
> 2. Sizes of databases migrated

The main databases were 50gb and 14gb and a host of 3 - 4 gb databases.

>
> 3. Adopted migration plans - I could not find anything on the Sybase web
> site.

See point 1. Remove 11.5, install 12, configure your caches, total memory,
remote servers, worker processes, etc, add logins, resize master and tempdb,
drop tempdb's default and logsegment segments from master, create a 50mb
device and make it the default device (removing master as the default
device), install and configure dbccdb and reload from dumps for your user
databases. DO NOT LOAD master or any system databases from a dump. DBCC your
databases as soon as possible. you know the drill ...


> 4. Experiences on ASE 12.
>

I'm working with an MS Cluster and am looking to test v12 in the cluster as
opposed to two 11.9.2.1 servers, so I have nothing to report on that front.
I also haven't tested Rep Server with v12 yet. I am using v12 as far as
acceptance environments at present. The new merge-join looks like it does
v12 justice and i am interested in the future optimiser enhancements that
are planned.


Anonymous Posted on 2000-10-31 21:03:48.0Z
From: Anonymous@sybase.com
Date: Tue, 31 Oct 2000 16:03:48 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: Migration to ASE 12 from ASE 11.5
Message-ID: <995EF0661778E9440073B47885256989.0062C0608525687E@webforums>
References: <gX7jsOrb$GA.184@forums.sybase.com> <AkK3c$Yc$GA.223@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 sybase.public.sqlserver.nt:1532
Article PK: 1089010

Andy,

Have you done an 11.3 to 12.0 migration? Any tips on gaps between the two?