techmaddy.com

Reverse Engineering a Live DB with Visio 2003 and MySQL WorkBench

August 4th, 2010 kumarasamy No comments

Reverse Engineering is a very powerful technique for discovering the structures of databases.It is particularly useful for operational databases for which no up-to-date documentation is available. This will be very useful when you are taking up an application for either support/development. Basically this gives the understanding between the tables and their relationships. We have many commercial tools available to generate the Reverse Engineering, Now we’ll see the MS Visio 2003 to generate the reverse engineering in Oracle 9i.

The steps for creating the reverse engineering in Visio as follows,

Create a User DSN in Administrative Tools -> Data Sources (ODBC)
Set-up the ODBC Bridge Details for Oracle. These two steps creates the DSN for you.
Go to DataBase -> Reverse Engineer in Visio.
In Reverse Eng Wizard -> Select the Appropriate Installed Visio Drivers -> Setup
In ODBC Generic Driver Setup -> Select your associated Drivers and Select the DSN also
In Reverse Eng Wizard -> Select the DSN added -> Next
In Reverse Eng Wizard -> Select the Objects to Reverse Engineer -> Next
In Reverse Eng Wizard -> Select the table to Reverse Engineer -> Finish

Create a User DSN in Administrative Tools -> Data Sources (ODBC)

Set-up the ODBC Bridge Details for Oracle.

Go to DataBase -> Reverse Engineer in Visio.

Select the Appropriate Installed Visio Drivers.

Select your associated Drivers and Select the DSN also.

Select the DSN added -> Next

Select the Objects to Reverse Engineer

Select the table to Reverse Engineer

Final ER Diagram

Reverse Eng. With MySQL Workbench

The exact procedure to do reverse engineering with MySQL Workbench is available here.

Final Reverse Eng. With MySQL Workbench

Categories: General, Tools Tags: Database, MySQL, SQL, Tools

Keep your Quick Launch Simple

July 16th, 2010 kumarasamy No comments

Some times we’ll endup in having lots of shotcut icons on our desktop/quick launch toolbar. I was wondering how to reduce that since that looks very ugly for me to have long list of icons hanging on your quick launch bar.I was remembering that my room met was using some kind of utility to avoid this. After numerous trials i have got the answer back

Create the shortcuts for all of your application which you wanted to get rid of from quick launch,into a folder(In my case it’s “D:\Kumar\Shortcuts”). I have followed the other quciker work around whcih is having call names for all the applications

. My list looks like the following. (i.e FF will call Firefox, EC will call Eclipse, ME will call to MyEclipse)

Now how do i make this work through my “RUN” command in windows.

Go to My Computers -> Properties -> Advanced -> Click in Environment Variables -> Change the System Variable “PATH” like the following..

So you are going to append your folder(”D:\Kumar\Shortcuts”) with the existing value in “PATH”. After this go to Run command and type “FF” it should be opening FireFox for you.

Hope you liked it.

Categories: General Tags: Porting, Quick Launch, Tools

about:config trick for window.close() In Firefox

July 7th, 2010 kumarasamy No comments

This article is from my exp. on turning on the configuration in FF after each release.The script window.close() won’t work after every release from mozilla. The reason i found was “dom.allow_scripts_to_close_windows” in all.js will be set to false by default. I was trying to do it in the hard way,i.e Go to the location of all.js and change it manually. But i found a another easy method we can call the about:config page in FireFox, we can toggle it easier. The following shows how to do it.

Enter about:config in location bar

Shows all the options available

Search for dom.allow_script

Highlight the entry dom.allow_scripts_to_close_windows and double click to toggle to true

Then write a simple script to check window.close()

Categories: General, Open Source Tags: FireFox, Personal, Tools

Older Entries

Archive

Reverse Engineering a Live DB with Visio 2003 and MySQL WorkBench

Keep your Quick Launch Simple

about:config trick for window.close() In Firefox

Recent Posts

Archives

Twitter

Categories

Blogroll

Map