Just responding to a post of Tim's I thought it would be a good idea to start a thread about this so that we can, hopefully, collect all the hidden features together where we can all learn what's there.

My starter

Drag'n'Drop object to new sql window
Most useful for tables - open session, database, tables. Open a new sql window and drag a table from the left hand treeview onto it and it adds the code to create the table and optionally insert the rows. I use it to keep some tables in sync between development and live systems

Run a function
Double click a function and EDBManager will ask for parameters and execute it (OK there is a menu option for this as well)

Roy Lambert

Ok, I'll play...

When you're working on a live resultset, you can right click on a cell and set special values such an null easily. You can also double click on blob field a see it content in a proper fashion.

Regards,
Mane

"Easy Upgrade SQL Generation"

-  Client has DB "A".
- You have worked on this in your offices upgrading it "B".
- EDBManager can generate the FULL SQL SCRIPT needed to upgrade A to B.

In Edb create databases A and B

Click on "A" and right click "Reverse Engineer Database", in Window select "Upgrade" in Upgrade Options select "B".

EDBManager will generate a "DIFF SQL" ... brilliant feature, saves me hours when I am doing a major upgrade.

It also allows you to spot / check differences between DBs which ought to be identical in structure but are not.

Damn it Adam,

I used to manually use DATABASE COMPARE / SchemaDiff to achieve the same result, but this method seem a whole lot more easy. Thank you!

Regards,
Mario

>>Damn it Adam,

>>I used to manually use DATABASE COMPARE / SchemaDiff to achieve
>>the same result, but this method seem a whole lot more easy. Thank you!



Roy is right about the "Hidden Features" !!

One of the best is dragging any item from the Tree (i.e. Function, Procedure, Table) into a SQL window & getting auto-SQL.

Another useful one is the "SQL History" window in the "Explorer" menu, which shows a list of SQL you have run.

Another one is the "Object Search" (also in explorer) which lists all items in a DB which contain a string you list. This is REALLY USEFUL for identifying FUNCTIONS, PROCEDURES etc. which reference a Table prior to making a change of that table, to ensure you change the relevant FUNCs and PROCs first.