Geek Answers Handbook

Import custom XML into SQL Server

Is it possible to parse and import an arbitrary XML file into SQL Server tables using C #?

An XML file can be highly hierarchical.

I have a 1 Gb XML file, I don’t know anything about it.

How can I determine which tables it contains, create them on SQL Server and upload data to SQL Server?

Is it possible?

-1
source share
1 answer

No.

XML and SQL are very different things. You can take SQL data and save it in XML, and such SQL-like XML can be converted back to an SQL database, but arbitrary XML that did not originate from a SQL-like system is unlikely to be easily converted to SQL databases by any significant way.

SQL, XML , SQL .

+1

More articles:


All Articles