BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 08-10-2005, 05:23 PM   #1 (permalink)
CrackBerry Addict
 
Join Date: Aug 2004
Model: 9650
Carrier: Sprint
Posts: 655
Post Thanks: 0
Thanked 3 Times in 2 Posts
Default SQL vs MSDE

Please Login to Remove!

I can google this all day long but in laymans terms, if you were to try and justify spending 3k on a one user SQL server license vs simply using MSDE, how would you best describe the differences. (other than the lack of support with MSDE) ?
Offline  
Old 08-10-2005, 06:16 PM   #2 (permalink)
Talking BlackBerry Encyclopedia
 
greywolfe's Avatar
 
Join Date: Mar 2005
Location: NSW, Australia
Model: 8100
Carrier: optus
Posts: 303
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

SQL server will support more users and IMHO is more stable than MSDE. You can also then use SQL for other applications. SQL allows you to adminster the database directly and allows you to situate it on a remote machine, if you so wish.

Just a rough guide, I'm sure theres more benefits.
__________________
BES Admin, sometime God.
Offline  
Old 08-11-2005, 09:27 AM   #3 (permalink)
CrackBerry Addict
 
T-Roy's Avatar
 
Join Date: Jan 2005
Model: 8800
Carrier: Darth Vader
Posts: 704
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
SQL allows you to adminster the database directly and allows you to situate it on a remote machine, if you so wish.
MSDE does all of that... for a graphical view of your MSDE database you have to additionally install the manager application which is available.

To put MSDE remote you need to enable protocols during install or via the network configuration utility.

MSDE limits 8 concurrent connections
MSDE database cannot grow beyond 2gb

Those are the biggest limitations of MSDE that I can remember.
Unless your BES is going to have more than 200 users on it, it should be fine to use MSDE.

As far as googling all day...
http://www.google.ca/search?sourceid...&q=msde+vs+sql
First result looks good to me

Last edited by T-Roy : 08-11-2005 at 09:39 AM.
Offline  
Old 08-11-2005, 06:27 PM   #4 (permalink)
Talking BlackBerry Encyclopedia
 
greywolfe's Avatar
 
Join Date: Mar 2005
Location: NSW, Australia
Model: 8100
Carrier: optus
Posts: 303
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by T-Roy
MSDE does all of that... for a graphical view of your MSDE database you have to additionally install the manager application which is available.
My point is that SQL does this by default, MSDE doesnt.
__________________
BES Admin, sometime God.
Offline  
Old 08-15-2005, 04:18 PM   #5 (permalink)
New Member
 
Join Date: Aug 2005
Model: 7250
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have BES 4.0 w/ database on SQL server. I *should* be seeing one SQL instance for every BlackBerry user, correct?
Offline  
Old 08-15-2005, 04:44 PM   #6 (permalink)
Thumbs Must Hurt
 
Join Date: Jun 2005
Model: 8320
Carrier: T-Mobile
Posts: 108
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

No, one database per BES server and not per user. I would go with SQL over MSDE just for the stability, ease of administration and not having to be limited. Also, you can use the SQL Server for other non-BES databases for testing or whatever apps out there uses SQL.
Offline  
Old 08-15-2005, 05:12 PM   #7 (permalink)
Talking BlackBerry Encyclopedia
 
udontknowjack's Avatar
 
Join Date: Aug 2004
Location: State of Confusion
Model: 9000
Carrier: T-Mobile
Posts: 483
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by DIS_Julia
I have BES 4.0 w/ database on SQL server. I *should* be seeing one SQL instance for every BlackBerry user, correct?
The only SQL instance you shold see is your BESadmin account.
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

CIO-DAC16 Measurement Computing Analog Output Module CI0-DAC16
$78.0
CIO-DAC16  Measurement Computing Analog Output Module CI0-DAC16  pictureSMA industrial computer DAO4-C1 analog output
$499.0
SMA industrial computer DAO4-C1 analog output pictureIOTech ADC488/16 Measurement Computing Analog-Digital Converter ADC
$28.83
IOTech ADC488/16 Measurement Computing Analog-Digital Converter ADC pictureNEW OMEGABUS D3172 Omega RS485 to Analog Output Module
$130.0
NEW OMEGABUS  D3172 Omega RS485 to Analog Output Module pictureMeasurement Computing PCI-DAS1602/16 High-Speed Analog Input Board
$149.99
Measurement Computing PCI-DAS1602/16 High-Speed Analog Input Board picture






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