BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 10-29-2007, 03:12 PM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Mar 2006
Location: Canada
Model: 7290
Carrier: Rogers
Posts: 35
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default MSDE 2000a vs SQL 2000?

Please Login to Remove!

What is the difference between the 2 database program for BES v4.13 for GroupWise 7? Plan to have less than 15 BES users. Currently will have one BES running all BES services?

If I pick MSDE (as I don't need to buy SQL2000), will I regret the decision? And if yes, can I have the BES server also as the SQL 2000 database server?

Thanks
Che
__________________
Che
Offline  
Old 10-29-2007, 03:21 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

The versions of SQL 2000 is the same for GW, Domino, or Exchange ...

I would stick with MSDE as it is free and can easily support a few hundred users.

You might look to Microsoft for a comparison of the editions.

You could in theory have the BES be a DB server for other services but it isn't recommended due to the built in governor of MSDE.

From a database structure standpoint MSDE is the same as SQL 2000 Standard / Enterprise.
Offline  
Old 10-29-2007, 06:11 PM   #3 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2006
Model: 9700
Carrier: Rogers
Posts: 39
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I agree with hdawg. You can use the free MSDE version for now (15 users is peanuts) and if you want to upgrade to SQL, you can upgrade your MSDE database easily.

SQL vs MSDE is like anything light vs feature rich. SQL handles more requests per second and you get a nice interface. MSDE is super basic, simple to maintain and it is upgradeable.

Enjoy.
Offline  
Old 10-30-2007, 07:27 AM   #4 (permalink)
CrackBerry Addict
 
Join Date: Jul 2005
Location: Solon, OH, USA
Model: 9000
OS: 4.6.0.167
PIN: 20878533
Carrier: ATT
Posts: 708
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have a similar number of users (17) and don't regret the decision to stay on MSDE2000. Like Hdawg said (and is also RIM's stance) is you don't need SQL until you have more than a few hundred users.

Our emails and calendar updates get pushed to the devices within 2-20 seconds and PIM sync (address book journal/memos) are synced in about 20-50 seconds. I don't perceive MSDE (according to the logs) to be a bottleneck at all for my setup. I do think this is really amazing given that MSDE has a governor, yet BES can cope with that just fine in small deployments (even past a hundred users) is amazing.

If anything lowering the latency (if you are above the 100-200ms range) between the BES and your mail store is probably a bigger win, performance wise.
__________________
--
Domino 7.0.4FP1 | BES 4.1.6 MR-7 | 42 handhelds
Offline  
Old 10-30-2007, 07:55 AM   #5 (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

Make sure you also backup your MSDE database.
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.