Generating SqlServer db out of DataSet

12 Oct 2006 11:30 AM

Edgile

Hi,

I have a XSD schema from which I generate a DataSet and then I need a db as
well to persist the content. As the schema is still not finished, I do not
want to synch the db and the schema all the time manually, so I wonder if
there is any tool that could (re)generate the SQL Server db for me any time
as the schema evolve. (The schema does not change in runtime.)

Thanx in advance,

Edgile

12 Oct 2006 12:41 PM

Cowboy (Gregory A. Beamer)

You will have to write the tool to do it. SOmeone may have already thought
of this, however.

Another option is to create a tool (or buy one) that generates the XSDs, but
your code might dictate schema (not a wise idea, but it happens), in which
case you are stuck with what you have in the XSD.

Design is one of the hardest parts of coding an application.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

*************************************************
Think outside of the box!
*************************************************

Show quote

"Edgile" <Edg***@discussions.microsoft.com> wrote in message
news:286DCD4E-5DF4-4529-BC2F-24D391AC42FF@microsoft.com...
> Hi,
>
> I have a XSD schema from which I generate a DataSet and then I need a db
> as
> well to persist the content. As the schema is still not finished, I do not
> want to synch the db and the schema all the time manually, so I wonder if
> there is any tool that could (re)generate the SQL Server db for me any
> time
> as the schema evolve. (The schema does not change in runtime.)
>
> Thanx in advance,
>
> Edgile