BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-04-2010, 10:54 AM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2005
Location: St. Petersburg FL
Model: 8700
Carrier: Cingular
Posts: 32
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Copy CAL's to a new server?

Please Login to Remove!

Hi,

I have a need to copy over 800 CAL's to a new 5.0.2 BES from a 4.1.6 BES. Support is telling me the only supported method is the interface or Enterprise Transporter tool. I'm using the transporter but only copy users to a new SRP ID.

Does anyone know of any 3rd party utilities or SQL tricks?

PLEASE SAVE ME FROM CARPAL TUNNEL!

Thanks,
Matt
Offline  
Old 08-04-2010, 12:29 PM   #2 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,647
Post Thanks: 264
Thanked 271 Times in 257 Posts
Default

From command-line, you can do the following:

bcp "select LicenseKey from BESMgmt.dbo.LicenseKeys where type = 0" queryout c:\licensekeys.txt -c -T -R -E -Sdbservername

That will export all installed license keys to the text file specified in the command. Just be sure to change dbservername to your SQL/MSDE server. This needs to be run from a server/machine that has bcp.exe installed, though (installed by default with SQL and MSDE installations).


I gues you can import them in a similar concept. I never tried it.
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10
Offline  
Old 08-04-2010, 01:17 PM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Apr 2007
Model: 9700
Carrier: AT&T
Posts: 155
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I copied and pasted them from the old database table to the new database table using SQL Server Management Studio.
Offline  
Old 08-04-2010, 02:17 PM   #4 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,647
Post Thanks: 264
Thanked 271 Times in 257 Posts
Default

Quote:
Originally Posted by icontech View Post
I copied and pasted them from the old database table to the new database table using SQL Server Management Studio.

Thats a nice trick to know.
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10
Offline  
Old 08-05-2010, 12:17 PM   #5 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2005
Location: St. Petersburg FL
Model: 8700
Carrier: Cingular
Posts: 32
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

We ended up doing something like that with SQL. Just an insert instead. The problem i had after that was that a trial CAL was still in there. Once i removed that it seemed to work okay.
Offline  
Old 08-06-2010, 08:34 AM   #6 (permalink)
Thumbs Must Hurt
 
Join Date: Sep 2009
Location: Ft. Bragg
Model: 9000
OS: 4.6.0.304
PIN: N/A
Carrier: ATT
Posts: 67
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

That's exactly what we did to. I was worried about that for a few days, I even called RIM and asked if we could turn in all our CALS (we had about 500 seperate ones), and get a few 200-300 user CALS. After being transfered 4 times, I got a "NO". So we just started searching the old DB, found them, found where they went on the new DB, and literally did a copy paste..... went flawlessly.
Offline  
Old 08-06-2010, 09:16 AM   #7 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2005
Location: St. Petersburg FL
Model: 8700
Carrier: Cingular
Posts: 32
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes same thing. Our mistake was that we let whoever purchases the user's BB to purchase the CAL. So we have about 800 CAL's all purchased from every single vendor possible... No hope in turning those in. We purchase them from now on though
Offline  
Old 08-08-2010, 07:19 PM   #8 (permalink)
Thumbs Must Hurt
 
BB1877's Avatar
 
Join Date: Feb 2005
Location: oHIo
Model: 9930
Carrier: Verizon
Posts: 163
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

So let me ask this...can you have the same CAL key on two servers at the same time?

I've been slowing moving 180 users from a 2.2 and 4.1 BES to a 5.0.1 BES...and just removing then readding a CAL key manually as needed (like a 10 pack).

Recently, I added the CAL key on the new box before removing it from the old one, and it took it. I then removed it from the old box. It seemed to validate the key, but not the fact that it was already in-use.
__________________
BES 2.2.3.11 5/19/04 until 8/31/10 RETIRED
BES 4.1.6.55/Domino 6.5.4 FP2 580 users RETIRED
BES 5.0.1/Domino 8.5.1 223 users RETIRED
Offline  
Old 08-09-2010, 08:26 AM   #9 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2005
Location: St. Petersburg FL
Model: 8700
Carrier: Cingular
Posts: 32
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I was told by support that the only time the CALs come into use is when you try to add more user's than CAL's. Any new users wont be able to activate or redirection cant be enabled (something like that).

So i don't think the BES communicates to RIM as to what CAL's you have installed.
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.