XSD generation from a MS SQL database using schemas
- by madprog
I'm willing to use NDbUnit on a MS SQL database which uses schemas.
I have to generate the XSD schema from the database. Visual Studio has a tool to do that, but Visual Studio 2005 doesn't include the schema information in the generated XSD.
Therefore, NDbUnit fails because the generated SQL queries do not match the database.
Worse, when I try to use Proteus, the XSD schema doesn't validate against the database, and Proteus fails with a warning telling that data could be lost if this check was skipped.
So, my question is: is there any tool that would generate my XSD schema properly and from the database information?