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: PRIV
OS: 5.1.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,177
Post Thanks: 361
Thanked 374 Times in 344 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.
__________________
unlock your phone here http://freemyblackberry.com/
I am on http://supportforums.blackberry.com
BES 12 running sweet for my DTEK60
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: PRIV
OS: 5.1.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,177
Post Thanks: 361
Thanked 374 Times in 344 Posts
Default

Good to hear.
__________________
unlock your phone here http://freemyblackberry.com/
I am on http://supportforums.blackberry.com
BES 12 running sweet for my DTEK60
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

HP 16096A Test Fixture for Impedance Analyzer
$399.99
HP 16096A Test Fixture for Impedance Analyzer pictureHP 41951a Impedance Test Kit for 4195a
$799.0
HP 41951a Impedance Test Kit for 4195a pictureHP 4194a Impedance / Gain-Phase Analyzer Opt 001, 350 (50 ohm)
$6495.0
HP 4194a Impedance / Gain-Phase Analyzer Opt 001, 350 (50 ohm) pictureHP 4194a Impedance / Gain-Phase Analyzer Opt 350 (50 ohm)
$5995.0
HP 4194a Impedance / Gain-Phase Analyzer Opt 350 (50 ohm) pictureAgilent 41941a Impedance Probe Kit for 4194a
$1295.0
Agilent 41941a Impedance Probe Kit for 4194a picture






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