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



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


Genuine A1417 OEM Battery Apple Macbook Pro 15 Retina A1398 Mid 2012 Early 2013 picture

Genuine A1417 OEM Battery Apple Macbook Pro 15 Retina A1398 Mid 2012 Early 2013

$37.90



NEW OEM Battery A1466 A1369 A1496 A1405 A1377 A1466 for MacBook Air 13 inch picture

NEW OEM Battery A1466 A1369 A1496 A1405 A1377 A1466 for MacBook Air 13 inch

$31.90



OEM iPhone 11 PRO X/XR XS MAX 8/7 PLUS Fast Charging USB Cable 10 Feet & 6 Feet  picture

OEM iPhone 11 PRO X/XR XS MAX 8/7 PLUS Fast Charging USB Cable 10 Feet & 6 Feet

$2.99



iPhone 13 12 11 PRO MAX XR XS 8/7/6 Fast Charger USB Data Cable cord 10 feet/3M picture

iPhone 13 12 11 PRO MAX XR XS 8/7/6 Fast Charger USB Data Cable cord 10 feet/3M

$4.99



A1618 NEW OEM Battery for MacBook Pro 15

A1618 NEW OEM Battery for MacBook Pro 15" Retina A1398 Mid 2015 020-00079

$43.90



OEM Battery for MacBook Pro 17

OEM Battery for MacBook Pro 17" A1309 A1297 Early 2009 Mid 2009 2010 MC226

$36.90







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