On Oct 6, 11:33 am, pamela fluente <pamelaflue...@libero.it> wrote:
> On 5 Ott, 20:33, Smitty <marksmith...@hotmail.com> wrote:
>
>
>
> > On Oct 5, 2:31 pm, "Martijn Tonies" <m.ton...@upscene.removethis.com>
> > wrote:
>
> > > > Hello everyone. I am brand new to mySQL, so I am not sure if this can
> > > > be done. Is there a way to capture a schema? I am taking over a
> > > > number of databases, and I'd like to get a better understanding of
> > > > each database. Thanks in advance
>
> > > What do you mean by "capture a schema"? Create a visual diagram from it?
>
> > > Yes, there are tools that can do that for you, both free and commercial.
>
> > > Ours is a commercial tool named Database Workbench, seewww.upscene.com
>
> > > --
> > > Martijn Tonies
> > > Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
> > > MS SQL Server
> > > Upscene Productionshttp://www.upscene.com
> > > My thoughts:http://blog.upscene.com/martijn/
> > > Database development questions? Check the forum!http://www.databasedevelopmentforum.com
>
> > Sorry, I wasn't more clear. Yes, a visual diagram would be great. I
> > am going to try the tool you mentioned. Thanks a lot.- Nascondi testo tra virgolette -
>
> > - Mostra testo tra virgolette -
>
> Another powerful one, free, will show all the DBMS details, including
> OleDBSchemGUIDs
> stored procedures, relations, types, etc.http://www.datatime.eu/download.aspx
>
> Create Connection > DatabaseExplorer > Reload structure etc ...
>
> Enjoy!
>
> -P

Thanks, I downloaded this tool, but am getting a "The 'MySQLProv'
provider is not registered on the local machine" error. I have to
look into this error and see what needs to be done.