get MySQL database schema

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
 
W

William Vaughn

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)
____________________________________________________________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

schema compare problem 4
Creating dataset.xsd file programmatically as dragging table from Server explorer fails 1
Anyone use Devart's MyDirect.NET and/or dbForgeFusion for MySQL? 6
Problems on adding a new dataset using MySQL via ODBC 5
create tables from XSD 1
How To Retrieve Database Schema? 4
Database connection issue using SQL schema user account 3
Copy database schema from Access to SQL Server 7

Top