BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 08-04-2010, 10:54 AM   #1
CaptMorgan
Knows Where the Search Button Is
 
Join Date: Aug 2005
Location: St. Petersburg FL
Model: 8700
Carrier: Cingular
Posts: 32
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
knottyrope
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: DT60
OS: 123456789
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,325
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.
__________________
I had to fall
To lose it all
But in the end
It doesn't even matter

Rocking the Motion with out lotion.
Offline  
Old 08-04-2010, 01:17 PM   #3
icontech
Thumbs Must Hurt
 
Join Date: Apr 2007
Model: 9700
Carrier: AT&T
Posts: 155
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
knottyrope
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: DT60
OS: 123456789
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,325
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.
__________________
I had to fall
To lose it all
But in the end
It doesn't even matter

Rocking the Motion with out lotion.
Offline  
Old 08-05-2010, 12:17 PM   #5
CaptMorgan
Knows Where the Search Button Is
 
Join Date: Aug 2005
Location: St. Petersburg FL
Model: 8700
Carrier: Cingular
Posts: 32
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
jjbova
Thumbs Must Hurt
 
Join Date: Sep 2009
Location: Ft. Bragg
Model: 9000
OS: 4.6.0.304
PIN: N/A
Carrier: ATT
Posts: 67
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
CaptMorgan
Knows Where the Search Button Is
 
Join Date: Aug 2005
Location: St. Petersburg FL
Model: 8700
Carrier: Cingular
Posts: 32
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
BB1877
Thumbs Must Hurt
 
BB1877's Avatar
 
Join Date: Feb 2005
Location: oHIo
Model: 9930
Carrier: Verizon
Posts: 163
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
CaptMorgan
Knows Where the Search Button Is
 
Join Date: Aug 2005
Location: St. Petersburg FL
Model: 8700
Carrier: Cingular
Posts: 32
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


GE Voltage Stabilizer 10 KVA Transformer Pri 175-235/190-260/380-520 Sec 120/240 picture

GE Voltage Stabilizer 10 KVA Transformer Pri 175-235/190-260/380-520 Sec 120/240

$648.00



Phoenix Contact Voltage Distribution Block Part No. 2315269 picture

Phoenix Contact Voltage Distribution Block Part No. 2315269

$30.00



Sola Constant Voltage Transformer; 95-130-190-260; 120V 60Hz picture

Sola Constant Voltage Transformer; 95-130-190-260; 120V 60Hz

$1200.00



DC 120V 200A Voltage Current Ah Capacity Meter Charge Discharge AGM LEAD LiFePO4 picture

DC 120V 200A Voltage Current Ah Capacity Meter Charge Discharge AGM LEAD LiFePO4

$29.90



Voltage Electricity Tester Volt Detector Test Pen AC Non-Contact Sensor 90-1000V picture

Voltage Electricity Tester Volt Detector Test Pen AC Non-Contact Sensor 90-1000V

$14.99



Voltage Electricity Tester Volt Detector Test Pen 12-1000V AC Non-Contact 2-PACK picture

Voltage Electricity Tester Volt Detector Test Pen 12-1000V AC Non-Contact 2-PACK

$15.95







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