Re: importing xml into sql server 7

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bertan ARI [MSFT] (bertan_at_online.microsoft.com)
Date: 09/28/04

  • Next message: Iain A. Mcleod: "Re: importing xml into sql server 7" 
    Date: Tue, 28 Sep 2004 13:53:46 -0700

    Bulkload offers SchemaGen option to create tables automatically on the
    server based on your AXSD. You may use Bulkload in VB script, any language
    supports COM or .Net languages via COM interrupts. 

    -- 
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Iain A. Mcleod" <mcleodia@dcs.gla.ac.uk> wrote in message
news:eOJl9jOpEHA.3252@TK2MSFTNGP14.phx.gbl...
> Thanks for the swift reply Roger.
>
> Are there any 3rd party add-ons that you or anyone else know about that
> would do the trick?
> Here's the situation:
> I have XSD documents describing my data (subject to design changes).  I
wish
> to write ASP.NET pages to deal with my data and would prefer to treat it
as
> xml and use xslt rather than datasets and datagrids.  The reason for this
is
> that my company has some rather funky generic client side scripts that
> request the data through http as xml and dynamically build/rebuild the
UI -
> it saves quite a bit on server load.
> However, I'm not convinced that storing the data as purely xml files at
the
> backend is a very safe or scalable option for a multiuser system.
Therefore
> I would like to store them in sql server.  Also note that I don't have any
> data yet as the app is still in design phase :-)
> I can easily load them into an XMLDataDocument in .NET, which contains a
> dataset object, so it would be relatively easy to use this to interface
with
> the db (I think that to do this I have to provide the sql to do this
through
> a data-adapter).  However that still leaves the issue of creating the
> tables...  I either have to do this manually, or else 3rd party tools...
> Am I going about this the right way???
>
> Many thanks again
> Iain
>
> p.s. is SQLXml available through .NET platform APIs or is it SQL Server?
I
> know that it uses VB in some way, but I'm a bit hazy on how...
>
>
>
> "Roger Wolter[MSFT]" <rwolter@online.microsoft.com> wrote in message
> news:ej9oJVOpEHA.800@TK2MSFTNGP14.phx.gbl...
> > None of the SQLXML features work with SQL Server 7.  What you are asking
> for
> > is available with XML Bulk Load in SQL Server 2000.
> >
> > -- 
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > Use of included script samples are subject to the terms specified at
> > http://www.microsoft.com/info/cpyright.htm
> >
> > "Iain A. Mcleod" <mcleodia@dcs.gla.ac.uk> wrote in message
> > news:uK6FKAOpEHA.592@TK2MSFTNGP11.phx.gbl...
> > > Is it possible to import an XSD into SQL Server 7 and automagically
> create
> > > the tables?
> > >
> > > Cheers
> > > Iain
> > >
> > >
> >
> >
>
>
  • Next message: Iain A. Mcleod: "Re: importing xml into sql server 7"

    Relevant Pages

    • Re: Same Internal Server Error from last two days
      ... I am trying to run a Hello World Perl Script in Apache 2.2. ... But its constantly giving me Internal Server Error.The script ... # have to place corresponding `LoadModule' lines at this location so the ...
      (perl.beginners)
    • Re: Insert table content into SQL Server from Access
      ... IDataReader is an interface which several RDBMS have "concrete" versions. ... and then ship down the xml to sql ... server via a stored procedure. ... and send the DataSet.GetXmldown to a Sql Server stored ...
      (microsoft.public.sqlserver.programming)
    • Re: Same Internal Server Error from last two days
      ... I am trying to run a Hello World Perl Script in Apache 2.2. ... But its constantly giving me Internal Server Error.The script Runs perfectly fine from the command prompt. ... # This is the main Apache HTTP server configuration file. ... LoadModule actions_module modules/mod_actions.so ...
      (perl.beginners)
    • Same Internal Server Error from last two days
      ... I am trying to run a Hello World Perl Script in Apache 2.2. ... But its constantly giving me Internal Server Error.The script ... # have to place corresponding `LoadModule' lines at this location so the ...
      (perl.beginners)
    • Re: Distributed Query: Import XML using OpenRowSet Bulk from UNC - access denied
      ... The security delegation should be setup for the service user account/port combination and registered. ... This is more of a general OpenRowset than XML question. ... connecting to SQL2005 Server B, the data is located on a server C at ... SQL server and verified this. ...
      (microsoft.public.sqlserver.xml)