Database Schema
-
Hi All, I am designing a database for an Intranet application. I would like to put together a diagram for the database schema. It should include the tables / fields / and links (similar to the diagrams done by Microsoft Access). Does anybody know of good free tools out there? It would even be better if this tool can import an SQL file ;P Thanks, Victor phpWebNotes is a page annotation system modelled after php.net. http://webnotes.sourceforge.net/demo.php[^]
-
Hi All, I am designing a database for an Intranet application. I would like to put together a diagram for the database schema. It should include the tables / fields / and links (similar to the diagrams done by Microsoft Access). Does anybody know of good free tools out there? It would even be better if this tool can import an SQL file ;P Thanks, Victor phpWebNotes is a page annotation system modelled after php.net. http://webnotes.sourceforge.net/demo.php[^]
If you have VS.NET Enterpise Architect, it comes with a version of Viso that can reverse engineer the database a draw a very good sceme for you from the ODBC link. Make changes to the scheme and then apply them back to the database. Its free in the sense they you may already have it and did not know???
"Je pense, donc je mange." - Rene Descartes 1689 - Just before his mother put his tea on the table. Shameless Plug - Distributed Database Transactions in .NET using COM+
-
If you have VS.NET Enterpise Architect, it comes with a version of Viso that can reverse engineer the database a draw a very good sceme for you from the ODBC link. Make changes to the scheme and then apply them back to the database. Its free in the sense they you may already have it and did not know???
"Je pense, donc je mange." - Rene Descartes 1689 - Just before his mother put his tea on the table. Shameless Plug - Distributed Database Transactions in .NET using COM+
Giles wrote: VS.NET Enterpise Architect Unfortunately, I don't have it. :( Thanks, Victor phpWebNotes is a page annotation system modelled after php.net. http://webnotes.sourceforge.net/demo.php[^]
-
Hi All, I am designing a database for an Intranet application. I would like to put together a diagram for the database schema. It should include the tables / fields / and links (similar to the diagrams done by Microsoft Access). Does anybody know of good free tools out there? It would even be better if this tool can import an SQL file ;P Thanks, Victor phpWebNotes is a page annotation system modelled after php.net. http://webnotes.sourceforge.net/demo.php[^]
Victor Boctor wrote: I am designing a database for an Intranet application. I would like to put together a diagram for the database schema. It should include the tables / fields / and links (similar to the diagrams done by Microsoft Access). Are you using SQL Server? Why not use the diagramming feature? Acting as a substitute for God, he becomes a dispenser of justice. - Alexandre Dumas
-
Victor Boctor wrote: I am designing a database for an Intranet application. I would like to put together a diagram for the database schema. It should include the tables / fields / and links (similar to the diagrams done by Microsoft Access). Are you using SQL Server? Why not use the diagramming feature? Acting as a substitute for God, he becomes a dispenser of justice. - Alexandre Dumas
Daniel Turini wrote: Are you using SQL Server? I am using MySQL/PHP. phpWebNotes is a page annotation system modelled after php.net. http://webnotes.sourceforge.net/demo.php[^]
-
Daniel Turini wrote: Are you using SQL Server? I am using MySQL/PHP. phpWebNotes is a page annotation system modelled after php.net. http://webnotes.sourceforge.net/demo.php[^]
Victor Boctor wrote: php.net. Huh. For a small second I thought there exists a PHP "compiler" for the .NET platform :-) -- - Free Windows-based CMS: www.zeta-software.de/enu/producer/freeware/download.html - See me: www.magerquark.de
-
Victor Boctor wrote: php.net. Huh. For a small second I thought there exists a PHP "compiler" for the .NET platform :-) -- - Free Windows-based CMS: www.zeta-software.de/enu/producer/freeware/download.html - See me: www.magerquark.de
That would be nice! Actually PHP5 should be able to interact with .NET! So I guess it is almost there ;P phpWebNotes is a page annotation system modelled after php.net. http://webnotes.sourceforge.net/demo.php[^]