Re: SQL Server to .xsd
From: Val Mazur (group51a_at_hotmail.com)
Date: 10/14/04
- Next message: Val Mazur: "Re: table.Rows.Find"
- Previous message: Val Mazur: "Re: Problem using LEN function in WHERE clause on OLEDB Jet 4.0 driver"
- In reply to: Dave: "Re: SQL Server to .xsd"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 13 Oct 2004 21:47:07 -0400
Hi Dave,
I do not know any such built-in capabilities. I think you would need to code
it using your own code.
-- Val Mazur Microsoft MVP "Dave" <DaveSmith3141@hotmail.com> wrote in message news:CE3B84E5-E5B8-4F99-84D4-752BFF2B6E3F@microsoft.com... > Interesting, but not exactly what I was looking for. I would like to > somehow > output an XSD from an entire database schema, or accomplish something to > the > means of synchronizing database changes to the internal schema of the > application so I don't have to do double duty. It would nice to have > "system" > dataset that represents the entire database but changes to the physical > SQL > db would change the dataset's schema. That's why I thought if there is > some > way to output an XML .xsd from SQL, I could just overwrite the old xsd > without going in making manual changes. May be a pipe-dream although I > don't > think it would be a difficult thing to do if I had the right tools. > > Thanks very much for your response. > > -Dave > > "Val Mazur" wrote: > >> Hi, >> >> Do you need to get schema of specific table in a SQL Server? If yes, then >> check next example >> >> http://support.microsoft.com/default.aspx?scid=kb;en-us;309488 >> >> -- >> Val Mazur >> Microsoft MVP >> >> >> "Dave" <DaveSmith3141@hotmail.com> wrote in message >> news:40EF9DFF-FCEC-4C07-A1EB-B430915FE079@microsoft.com... >> > I'm working on my first major project with .net and getting run over >> > with >> > maintaining two schema's one within SQL Server and then the schema >> > within >> > the >> > application. I worked with the XML schema briefly but was frustrated in >> > not >> > knowing how to make changes to it. Is there a way to produce the .xsd >> > file >> > from SQL Server and just overwrite the one that the applcation would >> > read >> > in? >> > This would change my life if there was a way to easily marry the two >> > together. Any good resources or advice would be greatly appreciated. I >> > am >> > using SQL Server 2000 which I know has tools to support XML >> > >> > Thanks in advance! >> > -- >> > -Dave >> >> >>
- Next message: Val Mazur: "Re: table.Rows.Find"
- Previous message: Val Mazur: "Re: Problem using LEN function in WHERE clause on OLEDB Jet 4.0 driver"
- In reply to: Dave: "Re: SQL Server to .xsd"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
