BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 11-17-2006, 10:15 AM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Nov 2006
Model: 8100
Carrier: Tmobile
Posts: 15
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Case to move from MSDE to SQL

Please Login to Remove!

What are some of the reason to move to SQL?

I need a present a case for it.

We have about 200 users running Lotus 6.5.4



Thanks
Offline  
Old 11-17-2006, 10:31 AM   #2 (permalink)
CrackBerry Addict
 
bertiebassett's Avatar
 
Join Date: Aug 2005
Location: London, UK
Model: 9700
Carrier: O2
Posts: 961
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

do you run SQL elsewhere...

erm.. more reliable, scalabale.. by detaching the dbase from the server makes adding in another server in the future easier...less of a single point of failure..
Offline  
Old 11-17-2006, 10:54 AM   #3 (permalink)
BlackBerry Extraordinaire
 
BBAdmin's Avatar
 
Join Date: Feb 2005
Location: Port 3101.org
Model: .
Carrier: .
Posts: 2,492
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

There are also arguements for running it in cases where you have a larger amount of users too.
__________________

Offline  
Old 11-17-2006, 11:12 AM   #4 (permalink)
Knows Where the Search Button Is
 
Join Date: Nov 2006
Model: 8100
Carrier: Tmobile
Posts: 15
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

What do you do if SQL server fails?

We are a oracle shop.
Offline  
Old 11-17-2006, 11:40 AM   #5 (permalink)
CrackBerry Addict
 
bertiebassett's Avatar
 
Join Date: Aug 2005
Location: London, UK
Model: 9700
Carrier: O2
Posts: 961
Post Thanks: 0
Thanked 0 Times in 0 Posts
Smile

Quote:
Originally Posted by HMAN
What do you do if SQL server fails?

We are a oracle shop.
hope you have a backup...

IANA SQL specialist but theres lots of stuff you can do with it that you can't do with MSDE like setting up a separate SQL instance to work as a backup db server and then cutting across to the backup instance if the original instance goes down. If you're interested in minimising BES downtime and you have 200 users then I'd think about switching...but you need to know the in/outs of SQL to gain benefit, so might need a consultant or get someone trained well in-house..
Offline  
Old 11-17-2006, 03:46 PM   #6 (permalink)
Knows Where the Search Button Is
 
jonpwil's Avatar
 
Join Date: Aug 2006
Model: 8100
Carrier: T-Mobile
Posts: 24
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by HMAN
What are some of the reason to move to SQL?

I need a present a case for it.

We have about 200 users running Lotus 6.5.4



Thanks
MSDE Database Limitations
MSDE is intended for single user or small workgroup environments. The following are some of the MSDE limitations in comparison with SQL Server:

No Enterprise Manager
No Query Analyzer
No Index Tuning Wizard
Only 2GB RAM
Only 2GB database size limit
Only 2 CPUs
Only five concurrent batch workloads or 25 concurrent connections for websites
No Database Server Failover Support
No Full-text search
No SQL Server Profiler
No Import and Export Wizards
No OLAP
No English Query
No SQL Books Online
No Full or Bulk-Logged recovery model support (only simple)
Offline  
Old 11-18-2006, 02:14 AM   #7 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

I thought a management interface is now included in SQL Express 2005?
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
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.