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,
Rose
Posted
Comments
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
   
Hello,

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. http://cmille19.wordpress.com/2009/05/23/create-database-diagrams-with-powershell-yuml/ (Based on yUML)
2. http://plantuml.sourceforge.net/index.html
3. http://code.google.com/p/modsl/
4. http://sourceforge.net/apps/mediawiki/textuml/index.php?title=TextUML_Tutorial

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