I believe you may be able to use SQL server bulk insert tool This may also be of some use
http://www.perfectxml.com/articles/XML/ImportXMLSQL.asp I recently had to do something similar on a 1.8 gig file and for some reason (which escapes me now) ended up just writing a java class to do it using SAX. HTH KOla > -----Original Message----- > From: Richard Colman [mailto:[EMAIL PROTECTED] > Sent: 17 June 2005 15:07 > To: CF-Talk > Subject: Importing XML into SQL-Server > > Anyone know of a good software tool to import very large (4GB) XML > document > into SQL Server? Would like smart tool to make up for not-so-smart > developer. > > BTW, tried ACCESS 2003 which has a very nice import facility for XML. > Unfortunately, it died around 464MB database file although specs say it > will > do up to 2 GB. > > Richard Colman > Institute for Genomics and Bioinformatics > [EMAIL PROTECTED] > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209815 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
