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


Vintage MAC Tools Inside Micrometer Set in Case/ With Manual picture

Vintage MAC Tools Inside Micrometer Set in Case/ With Manual

$100.00



Vintage Mac Tools AW343 Series 1/2 Pneumatic Impact Driver  picture

Vintage Mac Tools AW343 Series 1/2 Pneumatic Impact Driver

$50.00



Vintage Mac Warehouse  3.5” Floppy Disk Solar Powered Calculator Company Swag picture

Vintage Mac Warehouse 3.5” Floppy Disk Solar Powered Calculator Company Swag

$74.00



VINTAGE MSI McHenry Systems MAC IH ELECTRONIC DISTANCE METER SURVEYING picture

VINTAGE MSI McHenry Systems MAC IH ELECTRONIC DISTANCE METER SURVEYING

$350.00



Vintage MAC USA 18-6 XDM Six Points 18 MM Socket 3/8

Vintage MAC USA 18-6 XDM Six Points 18 MM Socket 3/8" Drive Used Excellent Condi

$14.99



Vintage White APPLE IMAC EMC 1857 15

Vintage White APPLE IMAC EMC 1857 15" 20GB HDD Mac OSX 10.2 256MB RAM 500MHz

$85.00







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