Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection

Rate this Entry

Bulk import BES CAL (license keys)

Submit "Bulk import BES CAL (license keys)" to Digg Submit "Bulk import BES CAL (license keys)" to del.icio.us Submit "Bulk import BES CAL (license keys)" to StumbleUpon Submit "Bulk import BES CAL (license keys)" to Google
Posted 05-11-2010 at 04:05 AM by hdawg

I was recently working with a friend who was building a new BES 5 environment / migrating from 4.x and had more than 200 CAL's that needed to be added to the database.

Adding through the BAS is a "one at a time" approach with no easy way to do the import ... but as we all know the keys are all stored in the BlackBerry Configuration Database (BESMgmt) in the licensekeys table. So we'd just add the data to the table in question, right? Well ... kinda.

I was going open up my favorite SQL Query Analyzer to do a simple:
INSERT INTO licensekeys
... but then I figured I bet there is a stored procedure that the BAS calls when it adds a key to the database ... and then I found insertkey. I don't know if the BAS uses it (I haven't bothered to look) but the insertkey SP does error handling and I guess is a little more "supportable".

So now, instead we have:
exec insertkey 'besx35-XXXXX-XXXXX-XXXXX-XXXXX', '0'
Do some copy / paste with Excel and you're good to go. Oh yeah, there's also deletekey ... guess what that does?
Posted in Tips & Tricks
Views 6111 Comments 1 Edit Tags Email Blog Entry
« Prev     Main     Next »
Total Comments 1


  1. Old Comment
    There is a RIM KB article about that. Search for BCP and CAL. Works with a SQL command line tools and uses a text file for all CAL for export and import.
    Works like a charm.
    Posted 05-11-2010 at 06:41 AM by magikweis magikweis is offline

All times are GMT -4. The time now is 04:48 PM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2019, vBulletin Solutions, Inc.


Content Relevant URLs by vBSEO 3.3.2 PL2