On Oct 9, 12:24 pm, pamela fluente <pamelaflue...@libero.it> wrote:
> On 9 Ott, 18:20, pamela fluente <pamelaflue...@libero.it> wrote:
>
>
>
> > 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- Nascondi testo tra virgolette -
>
> > - Mostra testo tra virgolette -
>
> OleDB driver here:http://sourceforge.net/projects/myoledb/

Thanks so much Pamela for your responses. I downloaded the OldDB
provider, and am getting this error now when trying to connect:
"Could not retrieve OleDB Data Types info from (schema not
supported)Could not retrieve information about OledDB data types
from" Thanks again for your