Click here to Skip to main content
14,238,549 members
Rate this:
Please Sign up or sign in to vote.
See more:
If I have a data dictionary which provide field name, data type and length in microsoft excel . Is it possible to generate ER diagram in a tool like Sybase Power designer? I am not so sure. I have never tried this before. Just so lazy to create a lot of table. do you have any ideas?

Best Regards,
Prasad Khandekar 3-Apr-13 16:36pm
Sybase Power Designer is capable of reverse engineering the database.
Cmajorros 3-Apr-13 23:34pm
I know that well. I used to use it to generate my DB File to ERD. But for generate the Datadic to ERD I really have no idea
Prasad Khandekar 4-Apr-13 3:55am

There is one possible way, involves programming. But should be very easy to achieve. Please have a look at following tools they allow you to create digrams using textual representation. I said little bit of programming because you will have to translate your xls file into those constructs and run the tool to generate the required diagrams.
1. (Based on yUML)

Hope this helps.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100