get MySQL database schema

  • Thread starter Thread starter skneife
  • Start date Start date
S

skneife

I have create a connection via Visual Studio Server Explorer of a
MySQL database.
Now, I need to get an schema of that database (xsd file).
I have added a new dataset typed file in my project but when I drag
the database''s tables on the daataset it comes an error that Visual
studio is unable to get the shema of that database.

Does anyone has an idea to do that ?
Thanks.

Sam
 
The ADO.NET GetSchema method comes to mind but this is a function of the
..NET Provider. If you're using a generic OLE DB or ODBC provider, I doubt if
you'll have much luck. This is one reason I stick with SQL Server Compact
Edition and other SQL Server editions...

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
 
Back
Top