What database development tool would you recommend to Eclipse Java developer?

Question

I am an experienced Java developer, used to all the nice features that Eclipse provides for Java development (in particular Ctrl+T to open type, Ctrl+Click or F3 to open referenced declaration, outline, ...). I really like this degree of comfort.

Now I have a project, where I need to do some changes in the existing database (stored procedures, etc.) and I am looking for a tool, which would give me the similar level of comfort. (The database is Sybase) In particular:

1. Edit/Modify the stored procedures
2. Have some syntax highlighting for stored procedures/sql
3. Some code completion (i.e. Table/View/Procedure/variable names)
4. Have an easy way to find a procedure (something like Ctrl+T), I don't like scrolling through the list of 100s of procedures in my DB
5. Have an easy way to navigate to referenced object (ie. from exec ProcName to the ProcName definition, or table, etc.)
6. Highlight/List the variable usages inside the procedure body

I have tried several free tools I found around (Eclipse Database Development, Oracle SQL Developer, some old version of Aqua Data Studio), but none of them seems to get even close to points 4. and 5., they cover (to some extent) just 1, 2, 3.

I am looking for tool recommendations, eventually hints, how to workaround the missing features (i.e. how to change my habits).

EDIT: Oracle SQL Developer is not limited to Oracle, but can be used for other databases as well (just needs JDBC diriver). See bottom of this page for detailed instructions.

Thanks

Answer 1

SQL Navigator has features 1 to 5. I don't know about 6.

But it is not free. Quite expensive actually, with the base edition at $870 and the Xpert edition at $2275.

Answer 2

also checkout pl sql developer http://www.allroundautomations.com/plsqldev.html but it is also not free

Answer 3

Finally, I settled down to Sybase Workspace, which is product from Sybase, built on top of Eclipse Database Development. It adds some features missing in Eclipse Database Development (i.e. nice stored procedure editor, with more completition, F3 to jump to declaration of variable or stored procedure, debugging, outline etc.). Formally, it has 1, 2, 3, 5. It does not have 4 and 6, but it has the feel of Eclipse, I am used to, so I feel quite comfortable with it.

The main advantage is that Sybase gives the license free for anyone, who has the Sybase database server license (but it does not seem they check it anyhow).