BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-11-2006, 01:13 AM   #1 (permalink)
New Member
 
Join Date: Sep 2005
Model: 7290
Posts: 13
Post Thanks: 0
Thanked 0 Times in 0 Posts
Arrow Can we edit the SQL Database relate to BES?

Please Login to Remove!

Hi,

When install BES with MDS, a SQL database is created to store all the data.
As example, there is tables like “UserConfig” and there stores all the details.

To capture BB related more information I need to create new tables and store data.
For that can I use the same database with adding extra tables to it?
Is it harm to BES database?

Or else do I have create a new Database in SQL server?

Because one of my friend told me to “Don’t touch the BES related SQL Database”

Janak
Offline  
Old 08-11-2006, 03:28 PM   #2 (permalink)
CrackBerry Addict
 
|||||||'s Avatar
 
Join Date: Jun 2006
Model: 7100
Carrier: Rogers
Posts: 615
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by youpul
“Don’t touch the BES related SQL Database”
“Don’t touch the BES related SQL Database”
Offline  
Old 08-11-2006, 05:11 PM   #3 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: Feb 2005
Model: 7280
Carrier: cingular, no wait, AT&T
Posts: 300
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by |||||||
“Don’t touch the BES related SQL Database”
QFT
The only thing you could do is simple queries.
Offline  
Old 08-12-2006, 06:21 PM   #4 (permalink)
CrackBerry Addict
 
qc_metal's Avatar
 
Join Date: Mar 2005
Location: Rockford, IL
Model: 9530
OS: 4.7.x
Carrier: Verizon
Posts: 590
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

You could create a view...
__________________
Provision, maintain, and report on users via web: the NEW BerryStats | FAQ
Offline  
Old 08-13-2006, 10:50 PM   #5 (permalink)
New Member
 
Join Date: Sep 2005
Model: 7290
Posts: 13
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

can i add extra tables to it?
Offline  
Old 08-14-2006, 01:10 AM   #6 (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

Quote:
Originally Posted by youpul
can i add extra tables to it?
Just try it and see if it breaks anything. When something is working, there's really no point in messing with it, especially if you didn't design it. As qc_metal suggested, why not just create a view, or why not just write script that can capture the data you want through another means rather than storage of it in that database, or why not just create a smaller database instance and have it write the information there?
__________________
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  
Old 08-14-2006, 05:10 PM   #7 (permalink)
CrackBerry Addict
 
|||||||'s Avatar
 
Join Date: Jun 2006
Model: 7100
Carrier: Rogers
Posts: 615
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by youpul
can i add extra tables to it?
Back it up first if you try this. I still stand by my original statement
Offline  
Old 08-14-2006, 08:55 PM   #8 (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

I wouldn't add extra tables or views. Service packs introduce schema tweaks and changes to the database, you don't want your tweaks to introduce a problem or conflict

Create a new db on the same server if you want to store extra data.

You don't want to put yourself in an unsupported configuration if something goes wrong. Running Selects are safe, dont modify data.
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.