BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-27-2007, 01:15 PM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2005
Model: 8700
Carrier: Cingular/AT&T
Posts: 17
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Upgrade server/switch from MSDE to SQL

Please Login to Remove!

Ok, I need to do two things. Move from BES 4.0.6 on a Win 2k server to 4.1 on a win 2k3 server and move the database from local MSDE to stand-alone SQL. I have instructions on moving the database, thanks to the members here, and I am wondering if I can do both of these things at once. Would this work:

1. Turn off win 2k server BES services
2. Build 2k3 server to 4.0.6 with same info as 2k server
3. Perform steps to move database from MSDE to SQL
4. Make sure the new server works, then upgrade 2k3 server to BES 4.1

Essentially, a knife-edge cutover while moving from MSDE to SQL. Would this work? Has anyone ever attempted something like this?
Offline  
Old 08-27-2007, 01:31 PM   #2 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'd do the upgrade first on the win2k server and then cut over to 4.1 SP4 on the new server ... but either will work.
Offline  
Old 08-27-2007, 01:32 PM   #3 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

BBAdmin might chime in with some sneaky way he thinks you should upgrade ... it requires a Snickers bar, 25 toothpicks, and a pack of gum.
Offline  
Old 08-27-2007, 01:47 PM   #4 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2005
Model: 8700
Carrier: Cingular/AT&T
Posts: 17
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by hdawg View Post
I'd do the upgrade first on the win2k server and then cut over to 4.1 SP4 on the new server ... but either will work.
I can see how that might be smoother, but I was hoping to have the old server in the original state in case any of this didn't work and I had to back out of it.

I guess I'll have to head out tomorrow and purchase some toothpicks.
Offline  
Old 08-27-2007, 01:47 PM   #5 (permalink)
Talking BlackBerry Encyclopedia
 
DarkWater's Avatar
 
Join Date: May 2005
Location: Waterloo, ON
Model: 8320
PIN: FFFFFFFF
Carrier: Rogers Wireless
Posts: 417
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by hdawg View Post
I'd do the upgrade first on the win2k server and then cut over to 4.1 SP4 on the new server ... but either will work.
Yeah either will work. Mostly that order can depend on if the old hardware you are moving from is capable of handling the new version. This was really only an issue for very small shops or people making jumps from 3.6 to 4.1.

Don't forget to use the CreateDB utility to create a new blank database of the same name on the SQL server, then do the backup and restore. If you upgrade first, use the CreateDB from 4.1, if you move then upgrade, use CreateDB from 4.0.
__________________
DarkWater


http://www.blackberry.com/support/
Offline  
Old 08-27-2007, 01:49 PM   #6 (permalink)
Talking BlackBerry Encyclopedia
 
DarkWater's Avatar
 
Join Date: May 2005
Location: Waterloo, ON
Model: 8320
PIN: FFFFFFFF
Carrier: Rogers Wireless
Posts: 417
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by BlackMail View Post
I can see how that might be smoother, but I was hoping to have the old server in the original state in case any of this didn't work and I had to back out of it.

I guess I'll have to head out tomorrow and purchase some toothpicks.
Also a good idea. Though if you have a backup of your database then you can always recreate your server within a few minutes. All the settings are stored in the database after all.
__________________
DarkWater


http://www.blackberry.com/support/
Offline  
Old 08-27-2007, 01:50 PM   #7 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by BlackMail View Post
I can see how that might be smoother, but I was hoping to have the old server in the original state in case any of this didn't work and I had to back out of it.

I guess I'll have to head out tomorrow and purchase some toothpicks.
My reason for doing it in place and then moving is that you only have the one codebase on the new server. Performing a backup will get you the same thing; but I can certainly understand wanting to have the old server to fail back to in this case.
Offline  
Old 08-27-2007, 01:56 PM   #8 (permalink)
Knows Where the Search Button Is
 
Join Date: Jun 2005
Model: 8700
Carrier: Cingular/AT&T
Posts: 17
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by hdawg View Post
My reason for doing it in place and then moving is that you only have the one codebase on the new server. Performing a backup will get you the same thing; but I can certainly understand wanting to have the old server to fail back to in this case.
That's a very compelling reason to do it that way. I think you are right, having the cleanliness of only one codebase will be worth the few extra minutes it would take to restore if something went wrong.

Thanks to both of you for the advice thus far. I'll keep checking this thread until Wednesday, when our upgrade is scheduled.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.