XSD generation from a MS SQL database using schemas

Posted by madprog on Stack Overflow See other posts from Stack Overflow or by madprog
Published on 2010-05-28T06:25:56Z Indexed on 2010/05/28 6:31 UTC
Read the original article Hit count: 284

Filed under:

visual-studio-2005

|

xsd

|

ndbunit

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?

© Stack Overflow or respective owner

Related posts about visual-studio-2005

How to open the solution physical folder with File Explorer in Visual Studio 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
I cannot even copy and paste that physical folder in properties window :( >>> More
How to edit Build system paths in Visual Studio 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I want to change the build system path for building my VC++ project in VS2005. When I try to build the project, I'm getting an error that a specified header file cannot be opened. I have that header file in "Microsoft SDKs\Windows\v7.0\Include". But the path present in 'Build system path'… >>> More
Switch to tab by typing a substring of its name in Visual Studio 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to navigate between tabs in VS similar to the emacs iswtichb-mode or Firefox ubiquity switch tab mode (https://wiki.mozilla.org/Labs/Ubiquity/Ubiquity_0.1_Author_Tutorial#Switching_Tabs) ? In these apps, you just type a substring of the title of the tab (or buffer for emacs) to switch… >>> More
Unable to install Visual Studio 2005 on Windows 7

as seen on Super User - Search for 'Super User'
After downloading Visual Studio 2005 SP1 and Visual Studio 2005 Upgrade for Vista to install Visual Studio 2005 on Windows 7, when I tried to intall Visual Studio 2005 SP1, I got this error message: The up patch cannot be installed by the windows installer service because the program to be upgraded… >>> More
How to prevent Project ASP.NET Configuration and Team Foundation Server from fighting

as seen on Stack Overflow - Search for 'Stack Overflow'
So, I am using visual studio 2005 (and team explorer 2005) with tfs 2008. I have installed both Visual Studio 2005 SP1 and VS80sp1-KB932544-X86-ENU.exe. I perform the following steps: Select Project-ASP.NET Configuration within Visual Studio 2005. Within Visual Studio 2005, attempt to perform… >>> More

Related posts about xsd

Why won't this Schema validate this XML file? [Source of both included - quite small]

as seen on Stack Overflow - Search for 'Stack Overflow'
The XML file: <Lista count="3"> <Pelicula nombre="Jurasic Park 3"> <Genero>Drama</ Genero> <Director sexo="M">Esteven Spielberg</Director> <Temporada> <Anho>2002</Anho> <Semestre>Verano<Semestre> </Temporada> </Pelicula> <Pelicula… >>> More
Why won't this Schema validate this XML file?

as seen on Stack Overflow - Search for 'Stack Overflow'
The XML file: <Lista count="3"> <Pelicula nombre="Jurasic Park 3"> <Genero>Drama</Genero> <Director sexo="M">Esteven Spielberg</Director> <Temporada> <Anho>2002</Anho> <Semestre>Verano</Semestre> </Temporada> … >>> More
xsd validation againts xsd generated class level validation

as seen on Stack Overflow - Search for 'Stack Overflow'
In my project I have very big XSD file which i use to validate some XML request and response to a 3rd party. For the above scenario I can have 2 approaches 1) Create XML and then validate against give XSD 2) Create classes from XSD with the help of XSD gen tool, add xtra bit of attirbutes and use… >>> More
Automatically extracting inline XSD from WSDL into XSD file(s)

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using a third party Web Service whose definition and implementation are beyond my control. This web service will change in the future. The Web Service should be used to generate an XML file which contains some of the same data (represented by the same XSD types) as the Web Service plus some… >>> More
xsd.exe C# file to XSD file

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an XML file that I used to create an XSD File and from there generated the C# code. However, during development I had to make some changes to that C# file. Is there a way I can use the xsd.exe tool to convert that C# file back into an XSD file? I'm hoping to avoid having to go and manually… >>> More