XML to MS SQL Server
Posted on 2002-07-12
I am using Visual Basic 6.0 and I have incoming XML documents that I want placing in a database. Currently the database is on MS SQL Server, though I may need to change this at a later date.
I can think of plenty of ways of importing the XML into a database, but I'd like to ask if anyone has an efficient way of doing this.
The current method I'm using is turning XML into an SQL Queries. This means that the query can now be made on any database. I can use either XSL or an object library (currently using XSL) to convert the XML to SQL Queries.
And then connecting to the MS SQL Server and executing the query.