From Product X to SQL Developer

I recently worked at a company that used "Product X" for all of it SQL and PL/SQL activities.  There’s no real need to reveal what "Product X" is, because this isn’t a post about whether as a product it was good, bad or somewhere in between.  "Product X" met the needs of the Oracle developers in the company, and that’s all that matters.  There was just one issue – for Product X, the company was paying a little under $100k annually in license fees.

Enter SQL Developer.  Similarly, it’s not particularly relevant whether I think, or anyone else at the company thinks its better or worse than "Product X".  What does matter is – can it do the required tasks of the developers.  And the answer to that is a resounding yes.  And once that question is answered, then paying any kind of annual license fee for Product X becomes not an intelligent business choice.  So the organisation is in the process of moving to SQL Developer.  The trick now is how to enforce assist🙂 the developers with moving to SQL Developer.  And the reality is – once you show developers how to re-map the shortcut keys in SQL Developer to match what they were used to in Product X, then the task is virtually done.

But some developers still clung to Product X…and hence were threatening a violation of a the no-longer current license agreement.  So the task then became – how to stop dissuade🙂 them from still using Product X.  This post gives you a few ideas on how you might want to tackle it.

Version 1

I assumed the best of our developers🙂 and put a simple login trigger to check if the program they’d connected with was "ProductX.exe".  If it was, then a job was submitted (via dbms_job) to pop an email to them to let them know that Product X was no longer the company standard. 

Version 2

But old habits die hard…and within a few days, some developers had renamed ProductX.exe to SQL Developer.exe and were back on the database thrilled with their ingenuity🙂 So the trigger was adjusted to also check the MODULE, as ProductX also set its session module value to "Product X".  But, you can’t keep a good developer down, and with a little assistance from hex editor, the module was now cleared.

Version 3

Most development tools, when they connect to the database, run a series of queries to check things like privileges and the like.  So by tracing a connection by ProductX, a list of cursors that were executed could be identified.  So the login trigger was altered to always submit a job.  The job would check the program and module were checked as before, but it would also check V$OPEN_CURSOR for the new session. If it contained a selection of the statements that Product X would execute, then the trap has been sprung🙂


So Version 3 has been active for a couple of weeks now, and plenty of emails have been sent.  It will soon be amended to terminate connections, and thus, the migration to SQL Developer will be complete🙂

7 thoughts on “From Product X to SQL Developer

  1. Heh! I can sooooo relate to this problem!…🙂
    (slowly getting everyone on SQLDeveloper from Product X, here. It’s a long fight, but it can be won)

  2. Wow – I’d feel very uncomfortable putting in stuff like this in order to fight against developers in any organisation. If developers are actively ignoring directives and using software illegally (thus potentially putting their employer at risk) I’d be wondering why they’re still there. Very unprofessional attitude to have (“I don’t want to change, and you can’t make me!”). Perhaps after Version 4 (terminate connections), you’ll need Version 5 (terminate employment)!

    • Hi Jeff,

      Its funny you should say that. Do you remember when we moved from expensive ProductY to less expensive ProductZ at a common client in Midland. Well (and admittedly, this may have been before you came onboard) the DBA’s there had to use the same “encouragement” for that migration….


      • “encouragement” haha🙂 Must have been before I started there. If I recall correctly, “ProductZ” was new to me as well – but of course I was happy to learn to get used to it. Ended up liking it quite well anyway. All the products have different advantages and disadvantages. A nice thing about being a contractor, working with other contractors, is that we generally are accustomed to learning to make do with whatever tools we’re given.

  3. Not many folks volunteer to change tools or habits on their own. That being said, if anyone needs a hand with this, I frequently provide webinars where I show how you can make this transition as painlessly as possible.

    • Thanks for stopping by Jeff. We’ve been conducting “your first day with SQL Developer” sessions with the developers here. Generally, its been a case changing fonts, colours, and keyboard shortcuts to match what they had in ProductX and from there it *should* be fairly smooth sailing.

      One good selling point is multiple and pinning of query result grids, something that ProductX didnt do so well🙂

      • >> We’ve been conducting “your first day with SQL Developer” sessions with the developers here
        Very cool!

        Feel free to pass along any feedback, good and bad!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s