IBM Data studio

A quick update on my experience.  The selects is working great, the only thing I am missing currently from my winsql is that I can click on a foreign key and it retrieves the row for me.

Optimization

Next week I am planning a in-depth analysis on my experience in optimization a data take on script. The scripts writes 20 million to a staging file then do data manipulation and writes to several different tables.

Then there is about 1 million records to be compared with the 20 million records and then written to a staging area and then manipulated before written to multiple tables.

IBM Data Studio

Because of the JAVA it takes a bit of resources and is a bit slow. Otherwise I have no complaints. All the database and sql management operations can be done on this tool.

Some searching may be required to do some advanced operations.

IBM Data studio

Update:

First impressions is not bad, the only current issue I have is the amount of data that has to be downloaded. The initial download is to installation package about 160mb then a further 800mb for the rest of the packages. 

New Development Tool

Downloading the IBM Data studio and will give feedback if it actually helps in a business environment. The reason for downloading is that I have a couple of functions and scripts that needs some debuging and statistical information. So hopes this helps.

Current development software is WINSQL...

http://www.ibm.com/developerworks/downloads/im/data/