Re: SQL Server to .xsd

From: Dave (DaveSmith3141_at_hotmail.com)
Date: 10/12/04 

Date: Tue, 12 Oct 2004 13:45:09 -0700

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

Relevant Pages

  • Re: Need help on how to organize users and objects
    ... Yes Oracle is a bit different than Sql Server, but I think you will get the ... It doesnt become part of any schema until you assign it. ... a new developer started to work. ... need the COMMON database which stores tables with generic data and generic ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server to .xsd
    ... > output an XSD from an entire database schema, ... > "Val Mazur" wrote: ... >> Do you need to get schema of specific table in a SQL Server? ...
    (microsoft.public.data.ado)
  • Re: xsd files only: enough to start writing app. code of a DB-related component ?
    ... (plugins to Eclipse... ... schema too: ... Nobody in his/her right mind coded up those XSD files ... They were dumped from an existing database with a tool. ...
    (comp.lang.java.programmer)
  • xSQL Object 2.5.2.7
    ... synchronizing SQL Server databases. ... Server 2000 database with a SQL Server 2005 database and generate ... history of the schema changes and provide for safe and ... differences, view the scripts of objects, filter results and more; ...
    (comp.software.shareware.announce)
  • Re: Exporting SQL Server data to XML
    ... for example, load the schema, right click the root element and create an ... Joe Fawcett ... I have been given a SQL Server database and an XSD file. ...
    (microsoft.public.sqlserver.xml)
Loading