Re: Load Data to SQL SERVER

From: Roger Wolter[MSFT] (rwolter_at_online.microsoft.com)
Date: 06/26/04

  • Next message: Kota: "SQL Mail failure" 
    Date: Fri, 25 Jun 2004 19:30:55 -0700

    This depends a lot on how much data you have to load and how complex the
    schema you're loading it into is. Updategrams are not really suited to
    loading large quantities of XML. Bulk Load is good for loading a lot of
    data and doesn't require a lot of coding but it does require a mapping
    schema to map the XML schema to the database schema. OpenXML is pretty easy
    to code and doesn't require a mapping schema but it has a tendency to run
    out of memory if you try to load very large documents. 

    -- 
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
"MK" <anonymous@discussions.microsoft.com> wrote in message 
news:20c8d01c45a00$53af6540$a301280a@phx.gbl...
> Which way will be easy to load XML data to SQL Server 2000
> 1. OPENXML
> 2. BULK LOAD
> 3. UpdateGRAM.
>
> Thanks
  • Next message: Kota: "SQL Mail failure"

    Relevant Pages

    • Importing schema file
      ... I have installed ADAM to import it, but when I load it i get ... cargar esquema: astUsername: La referencia SUP del atributo no ... Error loading schema from "LDIF File": ...
      (microsoft.public.windows.server.active_directory)
    • Mapper fails to load schema
      ... "Failed to load the source schema. ... Would you like to select another schema using BizTalk Type Picker?" ... If I remove the project reference it seems to find it. ... It would be great to have a product feedback section on Connect similar to the VS product group so we can highlight these issues as we find them. ...
      (microsoft.public.biztalk.general)
    • Re: Importing schema file
      ... Usually you use ldifde to load schema mods but that isn't LDIF format below... ... cargar esquema: astUsername: La referencia SUP del atributo no ...
      (microsoft.public.windows.server.active_directory)
    • Re: Very slow to serialize Xml file
      ... This posting is provided "AS IS" with no warranties, and confers no rights. ... No data will read if exception occur. ... You're using the same file to store both data and schema, ... just load it. ...
      (microsoft.public.dotnet.framework.compactframework)
    • Re: Next Version of GDI+ (maybe GDI+ 2.0)
      ... loading and manipulating of such files isn't lightning fast unless you have really powerfull dedicated hardware. ... to see whole image you need to read whole image, and then eventualy generate a smaller sample for display. ... BUT to have this smaler sample you need to load ALL the pixels of oryginal image. ...
      (microsoft.public.dotnet.framework.drawing)