i have drawn an er diagram for a database projecta dn i need a software which transfers this drawing to tables. would you pleaseintroduce me a good software which helps me to do this?
+1
A:
Several products do this, Sybase Power Designer will do this, ERwin will do this also. There are others
SQLMenace
2010-06-06 11:57:07
A:
You can use SQL Server Management Studio to diagram your database and generate the db code for you. The diagram will be stored in SQL Server itself so will respond to changes made elsewhere.
One of the flavors of Microsoft Visio can do this for SQL Server. (It used to be 2003 Enterprise Architect, I'm not sure what it is these days.)
MySQL WorkBench will do it for MySQL.
Of course you'll need to redraw your diagram with the tool.
roufamatic
2010-06-06 11:58:16
+1
A:
Do it yourself, by hand, carefully choosing your data types, indexes etc...
I don't think automated options give a result you would be proud of. I even doubt the other ways would give you a correct working result.
iDevlop
2010-06-06 12:05:58