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

> 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, see www.upscene.com



--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

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.

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

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.

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

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/

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