BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-02-2010, 10:02 AM   #1 (permalink)
New Member
 
Join Date: Jun 2009
Model: Storm
PIN: N/A
Carrier: Vodafone
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BB Professional v4.1 - MSDE to SQL 2005 (In-place upgrade)

Please Login to Remove!

We have BB Professional v4.1.4.3 installed on a Windows 2003 Server R2 member server. The BESMgmt database uses MSDE. We are about to upgrade this server to MS SQL Server 2005 for an application that also runs on this box. It will be an in-place upgrade of SQL. Which process should I follow to transition the BB BESMgmt database across to SQL 2005 from MSDE?

I've read KB03112 but this seems to be for moving a database to a different physical box. Or should I treat this as if this is a new installation, i.e.:

- Backup the BESMgmt database to disc
- Perform the upgrade from MSDE to SQL 2005
- Use createdb.exe to update the existing BESMgmt schema to that of the installed SQL version (SQL 2005) (by the way does createdb know which version of SQL it is dealing with and update the schema appropriately or do I need to do something else here?)
- Restore the database using the SQL Management Studio (I presume as it restores it uses the new schema it is being restored to?)

Any help gratefully accepted. Or slaps to the face for being a rookie...

Thank you,

Richard Lowe
Novice BB Manager
Offline  
Old 08-02-2010, 12:27 PM   #2 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,643
Post Thanks: 264
Thanked 269 Times in 255 Posts
Default

If you follow it as new SQL move, then it should work fine.

I have never tried inplace upgrade from MSDE, but a MSDE to SQL I have done before which was fairly easy.
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10
Offline  
Old 08-11-2010, 08:04 AM   #3 (permalink)
New Member
 
Join Date: Jun 2009
Model: Storm
PIN: N/A
Carrier: Vodafone
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the advice knottyrope, but I didn't need to do anything! The in-place upgrade of MSDE to SQL 2005 automatically upgraded all the databases. As far as BB Professional is concerned the SQL instance is the same, so everything just worked afterwards.
Offline  
Old 08-11-2010, 11:32 AM   #4 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,643
Post Thanks: 264
Thanked 269 Times in 255 Posts
Default

Good to hear.
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10
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.