SQL Developer saves the day



So you get a call at the weekend.....

"we need you to run some data update against our database to complete a migration task"

This is the final task in a very long process and one that has taken months to verify all the steps and complete.

Problem 1 is that this is SQL Server (and i'm no SQL Server expert)

 (before you oracle guys stop reading, don't this is useful for you too)

Problem 2 - due to my laptop rebuild a week ago I'm missing almost all software from my laptop

Problem 3 - due to "security" I don't have admin rights on my laptop to install

Problem 4 - this is a managed database to which we have no direct server access

So the pressure is on, this updated is needed "now" and i don't have any client available or any server access to be able to do this and no means of getting a client installed..... or do I?

To be able to "save the day" i need the following tools:

sqldeveloper - http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
jdk 8 - http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
7-zip portable - http://portableapps.com/apps/utilities/7-zip_portable
jtds - http://sourceforge.net/projects/jtds/files/

And the steps are as here:

1) unzip sqldeveloper to anywhere you like (somewhere that doesn't need admin rights...)
2) 'install' 7 zip portable to wherever you like (no admin right needed here)
3) using the 7zip program follow the excellent blog note here http://www.brucalipto.org/java/how-to-create-a-portable-jdk-1-dot-7-on-windows/ (i found from the GUI you have to use 7-zip -> open archive to view what's inside the .exe file) - also read the comments at the end for a shortcut for the latter processes
4) follow my own previous link on installing jtds 'plugin' for sql developer (making sure to use the newer jtds version as my blog is quite old now)  http://dbaharrison.blogspot.de/2014/11/sql-developer-and-sql-server.html

Once you've done all of that you have a fully working client to allow you to work with MSSQL (or indeed oracle) installed with out any need for admin rights.

Here is the screenshot showing sqldev working with mssql



This got me out of a hole - maybe it does the same for someone else

0 comments:

Post a Comment