Portable PL/SQL Developer

[Frank Rowan]

To Allroundautomation Users/Support,

My employer has provided me with PL/SQL Developer 5.1.x.x to perform DB analytical work to verify report integrity and investigate report issues against in-house copies of customer Oracle DBs.

On occasion, I need to travel to a customer site to perform similar work at their site while using their PCs. Often, that remote site does not have PL/SQL Developer. I am used to using PL/SQL to perform analysis of their DB, structure, data, etc. I am reluctent to carry an install to their site, install it on their local PC, use it during my tenure, deinstall it before leaving, etc. My office PC is a full desktop type, not a laptop.

Can anyone advise on the feasability of setting up a runtime version PL/SQL Developer on a CD-ROM or USB Jump Drive to use at a remote site without actually doing an install.

I want to stay within licensing restrictions while enjoying the benefits of using PL/SQL Developer temporarily at a remote location.

Regards,
Frank

 

[ScottMattes]

It seems like you should be able to.

I once had a work situation where the PC I was on wouldn't save registery settings from logon to logon. I did something (wrote a program, or used regedit) to save/restore the registry settings after each logon.

A problem that I forsee are that the CD/flashdrive wouldn't always be at the same disk drive address, so the registry entries would have to be modified. Not impossible to overcome, but something to keep in mind

 

[Marco Kalter]

If the PC at your customer site has Oracle Net installed, then there is no problem. PL/SQL Developer can run from your USB memory stick without any problems.

If your customer does not have Oracle Net installed, then you may want to add an Oracle10g Instant Client to the memory stick, and create a command file that first sets up the PATH environment variable for the 10g home and subsequently calls PL/SQL Developer. The TNSNAMES.ORA file will be customer specific of course. Note that for Oracle10g Instant Client support you will need to upgrade to PL/SQL Developer 6.0.

Preferences and other settings will be stored in the registry (hkey_current_user\software\allround automations\pl/sql developer), so you may want to import/export that when appropriate.