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

That's not good.

Let me test the OleDb driver. The last time I tried it worked just
fine (apart some little
fixes we had to make to remove the double Null char at the end of each
string).

Perhaps some changes have been made to the OleDB driver
which compromise the compatibility with the .NET OleDBSchemaGuid
class. I do hope not.

In case, I will search for the OleDbProvider which we used (time ago)
for the test
and that was working fine.

Keep in touch and in the meantime get familiar with the tool by using
it on other DBMSes.

I will be back soon.


PS
You can also experiment with third part drivers if you find it, by
using the "General connection" dialog.
-P