On 9 Ott, 17:40, Smitty <marksmith...@hotmail.com> wrote:
> 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.- Nascondi testo tra virgolette -
>
> - Mostra testo tra virgolette -

It's not an error. It's normal if you have not installed
the OleDB provider client (free) for MySQL.

Clearly, you need to install the OldDB provider to connect to the DBMS
(there is a link in the documentation).

For any question or problem, just get back to me or post on the group.

-P