Post reply

import xml

  • November 29, 2004 at 9:48 am

    #87218

    I have sizable xml files (3 200 meg files) to be imported into SQL2k.  I was also given an XSD file.  I tried using MS XML viewer, but it only support XDR to create the table structures.  How can I create an XDR file or create the tables relatively painlessly?

     

     

  • November 30, 2004 at 5:42 am

    #531836

    refer to this site for all you need

    http://www.perfectxml.com/Articles/xml/importxmlsql.asp

    Everything you can imagine is real.

  • December 5, 2004 at 2:35 pm

    #532586

    If the file is 200 MB we had issues with loading it in one shot, eventually we ended up splitting the file in to 8 files for approx 25 MB each and got it loaded


    paul

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply