Migrate 11.0.2.2 to 11.5

Currently our production Sql server version is 11.0.2.2 and i want to
upgrade to Adaptive Server 11.5.
I have already loaded 11.5 files into different directory (ie
/sybase/11.5 which is different from current sybase directory)
I dont intend to upgrade from existing version directly..I mean I want
to  have option of running SQL Server 11.0.2.2 or 11.5 one at a time

Can I do this ?
1 - Create new SQl Server 11.5
and 
2 - Use these tables sysdatabases(contains databases except
master,sybsystemprocs,tempd andmodel),sysusages and sysdevices from SQL
Server 11.0.2.2
and somehow put these tables into master database of 11.5 SQL Server
3 - Start 11.5 Server ( if it doesnt work I still have the 11.0.2.2
SQL     Server !! - without having to restore back the original
11.0.2.2     files)

Question ?
Is this step correct and workable ? ( I think it will work,,but need
some feedback from u guys )

Thanks
0
Zul
4/17/1998 11:50:35 PM
sybase.sqlserver.admin 2338 articles. 0 followers. Follow

1 Replies
498 Views

Similar Articles

[PageSpeed] 50

Zul Azmi Ahmad wrote:
> 
> Currently our production Sql server version is 11.0.2.2 and i want to
> upgrade to Adaptive Server 11.5.
> I have already loaded 11.5 files into different directory (ie
> /sybase/11.5 which is different from current sybase directory)
> I dont intend to upgrade from existing version directly..I mean I want
> to  have option of running SQL Server 11.0.2.2 or 11.5 one at a time
> 
> Can I do this ?
> 1 - Create new SQl Server 11.5
> and
> 2 - Use these tables sysdatabases(contains databases except
> master,sybsystemprocs,tempd andmodel),sysusages and sysdevices from SQL
> Server 11.0.2.2
> and somehow put these tables into master database of 11.5 SQL Server
> 3 - Start 11.5 Server ( if it doesnt work I still have the 11.0.2.2
> SQL     Server !! - without having to restore back the original
> 11.0.2.2     files)
> 
> Question ?
> Is this step correct and workable ? ( I think it will work,,but need
> some feedback from u guys )
> 

It sounds like you want to point both servers to the same data
devices.  This won't work.  When 11.5 first brings a database online,
it updates internal datastructures and system tables to the 11.5 format,
which the 11.0.x server won't necessarily understand.

You can install 11.5, leave the 11.0.x server in place, dump databases
from 11.0.x and load them into the 11.5 server.  The database dump will
be upgraded when you issue the "online database" command.  You can then
run the two servers in parallel until you complete your testing.  You
will need to allocate the additional disk space for the copy.
-- 
Bret Halford			Imagine my disappointment
Sybase Technical Support	in learning the true nature		
3665 Discovery Drive		of rec.humor.oracle...
Boulder, CO 80303
0
Bret
4/17/1998 3:34:30 PM
Reply:

Similar Artilces:

Question on migrating from 11.0.2.2 to 11.5
Hi- I am trying to migrate from 11.0.2.2 running on AIX 4.1.3 to 11.5 running on AIX 4.3. I have had real problems performing Sybase upgrades before so I have the luxury this time of having a seperate AIX 4.3 to test this migration on. As I understand from the docs I should be able to load a dump from my 11.0.2.2 server and load it directly into 11.5. This seems to have worked accept for the method that it allocated devices. I did not exactly match each allocation one for whe creating the database but the total data and log sizes matched exactly. Hoping to consolidate the ...

Downgrade from 11.0.3.2 to 11.0.2.2
Greetings! Could anyone list out the procedure to downgrade the the SQL Server from 11.0.3.2 and 11.0.2.2. I installed 11.0.3.2 on a separate directory and did the upgradation. I just want to prepare in advance to go back to 11.0.2.2 in case we face any problems with the new release. Thanks, - John John Smith wrote: > > Greetings! > > Could anyone list out the procedure to downgrade the the SQL Server from > 11.0.3.2 and > 11.0.2.2. I installed 11.0.3.2 on a separate directory and did the > upgradation. > I just want to prepare in advance to go...

Difference between IQ 11.0,11.1,11.2 and 11.5
PowerDesignor WarehouseArchitect 6.0 does not support IQ 11.2 and 11.5. Can the .def file for 11.1 can be used as is with 11.2 and 11.5 ? Any modifications need to be made to the .def file?Is there any patch available for this? Thanks Shashi Kanth shashi@systemlogic.com ...

Difference between IQ 11.0,11.1,11.2 and 11.5
PowerDesignor WarehouseArchitect 6.0 does not support IQ 11.2 and 11.5. Can the .def file for 11.1 can be used as is with 11.2 and 11.5 ? Any modifications need to be made to the .def file?Is there any patch available for this? Thanks Shashi Kanth shashi@systemlogic.com I have never used PowerDesignor WA 6.0 so I'm not sure what a .def file is, but I hope the following answers your questions. The are a lot of differences between the various versions of IQ, but each new version of IQ supports a superset of the previous version's syntax. So all iq commands found in 11....

upgrade 11.0.2.2 to 11.5.1 questions....
Our company plans on migrating from our 11.0.2.2 database on NT 3.51 to a new server running NT 4.0 and 11.5.1. What will be necessary for the migration? Can I simply load 11.5.1 on the new server, load the logins, create the databases 'for load,' and restore the database dumps from 11.0.2? Thanks, Patrick Bennett Patrick, Yes, essentially, you can do that. You might want to just install 11.0.2.2 over on NT 4.0 and get it running as it is today. You can install a basic server (just master/sybsystemprocs), then move the device files over to it and boot it. Then, ru...

Fw: Smoke [5.9.2] 23330 FAIL(X) hp-ux 11.11/64 (PA-2.0/64/2 cpu)
23323 was still OK, 23330 was the next smoke on this machine after 23323 and the first to show this pattern Forwarded by "H.Merijn Brand" <h.m.brand@hccnet.nl> ----------------------- Original Message ----------------------- From: "H.Merijn Brand" <h.m.brand@hccnet.nl> To: smokers-reports@perl.org Date: Tue, 21 Sep 2004 19:20 +0200 Subject: Smoke [5.9.2] 23330 FAIL(X) hp-ux 11.11/64 (PA-2.0/64/2 cpu) ---- Automated smoke report for 5.9.2 patch 23330 r3: PA8800 (PA-2.0/64/2 cpu) on hp-ux - 11.11/64 using gcc versi...

can not create sysprocdev when migration from 11.0.2 to 11.9.2
Hi: I upgrade Enterprise Server from 11.0.2 to 11.9.2 I follow the upgrade guide of "installing sybase Adaptive server Enterprise on Sun Solaris 2.x(sparc)" because the old version's sysprocsdev is only 30M so I recreate it as the guide say.the device name use the "sysprocsdev2" And the use the vdevno =1. when I do upgrade the errmsg is ************************* Sat Nov 27 07:25:08 1999: Restarting Adaptive Server.... Sat Nov 27 07:25:08 1999: (SQL command) shutdown Sat Nov 27 07:25:09 1999: (Shell command) /data2/syb119/bin/dataserver -sSYBASE_ SX -d/da...

Smoke [5.11.2] v5.11.2-168-gab10618 FAIL(M) netbsd 5.0.1 (i386/1 cpu)
Automated smoke report for 5.11.2 patch ab106183f6f6440236f5be52e2a171a63882946a v5.11.2-168-gab10618 p5netbsd: Intel 686-class (i386/1 cpu) on netbsd - 5.0.1 using cc version 4.1.3 20080704 prerelease (NetBSD nb2 20081120) smoketime 9 hours 10 minutes (average 1 hour 8 minutes) Summary: FAIL(M) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = make t...

Smoke [5.11.2] v5.11.2-185-g7598291 FAIL(F) netbsd 5.0.1 (i386/1 cpu)
Automated smoke report for 5.11.2 patch 759829140078d44db25a91e0ffe11464897ba65d v5.11.2-185-g7598291 p5netbsd: Intel 686-class (i386/1 cpu) on netbsd - 5.0.1 using cc version 4.1.3 20080704 prerelease (NetBSD nb2 20081120) smoketime 6 hours 42 minutes (average 50 minutes 22 seconds) Summary: FAIL(F) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = m...

Smoke [5.11.2] v5.11.2-160-g421f30e FAIL(XF) netbsd 5.0.1 (i386/1 cpu)
Automated smoke report for 5.11.2 patch 421f30ed1e95009450bdc7905bf3433ee806ea4f v5.11.2-160-g421f30e p5netbsd: Intel 686-class (i386/1 cpu) on netbsd - 5.0.1 using cc version 4.1.3 20080704 prerelease (NetBSD nb2 20081120) smoketime 7 hours 7 minutes (average 53 minutes 26 seconds) Summary: FAIL(XF) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = m...

Smoke [5.11.2] v5.11.2-117-g8b19c1f FAIL(Xm) netbsd 5.0.1 (i386/1 cpu)
Automated smoke report for 5.11.2 patch 8b19c1f8f171b4db09e0f4369f5fa72b488e66bd v5.11.2-117-g8b19c1f p5netbsd: Intel 686-class (i386/1 cpu) on netbsd - 5.0.1 using cc version 4.1.3 20080704 prerelease (NetBSD nb2 20081120) smoketime 4 hours 4 minutes (average 30 minutes 35 seconds) Summary: FAIL(Xm) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = m...

Smoke [5.11.2] v5.11.2-138-gbb61cbb FAIL(F) netbsd 5.0.1 (i386/1 cpu)
Automated smoke report for 5.11.2 patch bb61cbbfe4f34b8082fca34dd9dd82cae6aaa146 v5.11.2-138-gbb61cbb p5netbsd: Intel 686-class (i386/1 cpu) on netbsd - 5.0.1 using cc version 4.1.3 20080704 prerelease (NetBSD nb2 20081120) smoketime 6 hours 34 minutes (average 49 minutes 19 seconds) Summary: FAIL(F) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = m...

Smoke [5.11.2] v5.11.2-192-g874e337 FAIL(F) netbsd 5.0.1 (i386/1 cpu)
Automated smoke report for 5.11.2 patch 874e3373547921774d47753e5cb8b5980422af81 v5.11.2-192-g874e337 p5netbsd: Intel 686-class (i386/1 cpu) on netbsd - 5.0.1 using cc version 4.1.3 20080704 prerelease (NetBSD nb2 20081120) smoketime 6 hours 48 minutes (average 51 minutes 6 seconds) Summary: FAIL(F) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = ma...

Smoke [5.11.2] v5.11.2-20-g074f7b7 FAIL(XM) netbsd 5.0.1 (i386/1 cpu)
Automated smoke report for 5.11.2 patch 074f7b78c4d97c74b49b2220b52710cd138da795 v5.11.2-20-g074f7b7 p5netbsd: Intel 686-class (i386/1 cpu) on netbsd - 5.0.1 using cc version 4.1.3 20080704 prerelease (NetBSD nb2 20081120) smoketime 5 hours 21 minutes (average 40 minutes 13 seconds) Summary: FAIL(XM) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = m...

Web resources about - Migrate 11.0.2.2 to 11.5 - sybase.sqlserver.admin

1-800-Flowers Becomes the First Client to Migrate to Facebook’s Revamped Atlas Ad Platform
... platform , which Facebook announced at Advertising Week 2014 in New York at the end of September, has its first client, as 1-800-Flowers migrated ...

Facebook Migrates 400,000 Users to Fans of Apple’s Page
While Facebook has been turning up the marketing on businesses and brand owners to create Facebook Pages, one feature of Pages that is less well ...

Why, when and how to migrate to Windows 8 - Windows 8 migration, Windows 8 deployment, Windows 8, Windows ...
Windows 8 machines are coming out sometime this fall, but that doesn't mean businesses should shift to panic mode to upgrade their corporate ...

'You don't migrate to this country unless you want to join our team': Tony Abbott renews push on national ...
Prime Minister Tony Abbott has elaborated on his "Team Australia" remarks, telling a radio interview that "you don't migrate to this country ...

Tony Abbott's woman problem migrates to his ministry
Tony Abbott is having women trouble. It's nothing he said, mind.

Doctors and Nurses From Poor Countries Migrate To Rich Ones
Australia has saved almost $640 million by poaching doctors from some of the poorest countries in Africa.

ISIS recruitment video Join the Ranks urges Indonesian Muslims to migrate to the Islamic State
A video released by the terrorist group shows Indonesian men urging Muslims to wage join the jihad.

Polar bears migrate to Canadian Arctic for longer lasting ice: study
Some polar bear clusters have slowly moved to islands north of Canada's mainland that are retaining the Arctic ice for longer, according to a ...

Apple now allows developer MobileMe users to migrate their accounts to iCloud
As promised, Apple has opened up a new portal at me.com/move for developers that the MobileMe service to migrate their entire account over to ...

Verizon Explains the Real Reason Geese Migrate
Every weekday, we bring you the Ad Age/iSpot Hot Spots , new and trending TV commercials tracked by iSpot.tv , a company that catalogs, tags ...

Resources last updated: 12/1/2015 9:15:10 PM