Convert SQL to XML

Want to convert SQL file to XML file?

If you want to export SQL Server to XML, see this page: SQL Server to XML.

If you want to export SQLite to XML, see this page: SQLite to XML.

Try Withdata Data File Converter, a desktop SQL to XML converter for Windows, MacOS, and Linux, Convert SQL to XML, Easy and Fast.

• Can run in GUI mode, Step by Step, just a few mouse clicks.
• Can run in Command line, for Scheduled Tasks and Streams.
• Convert files locally and privately, avoid uploading large SQL file(s) to online services.
• Support Windows, Linux, and macOS.

Download DataFileConverter
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Convert SQL to XML

Choose SQL file -> Set XML file -> Convert SQL to XML

“Start a New Convert” for “SQL to XML”.

Select From “File” “SQL” To “File” “XML”.

1. Open source SQL file.

Support large SQL file ( > 4GB ).

Source SQL file’s content is like this:

2. Config target XML file.

3. Set rows options.

4. Convert SQL to XML.

After converting, you can view the output XML file.

---

More about SQL to XML converter

See Video: Convert SQL file to XML file in a few clicks

See also:

• Merge multiple SQL files into one XML
• Batch convert SQL files to XML files

SQL → XML reference

Type mapping

Value kind	in SQL	in XML
Int	INT	<int>1234</int>
Bigint	BIGINT	<bigint>9007199254740993</bigint>
Decimal	DECIMAL(p,s)	<decimal>1234.56</decimal>
Float	DOUBLE PRECISION	<float>1.234e10</float>
Text	VARCHAR(n)	<char>text</char>
Long text	TEXT / CLOB	<text>multi-line text</text> (entities for &amp; &lt;)
Date	DATE	<date>2026-09-18</date> (xs:date with an XSD)
Datetime	TIMESTAMP	<datetime>2026-09-18T14:30:00Z</datetime> (xs:dateTime)
Binary	BLOB / BYTEA	<blob>base64...</blob> (xs:base64Binary)
Boolean	BOOLEAN / SMALLINT	<bool>true</bool>
JSON	JSON / TEXT	escaped inside an element, or its own sub-tree

Dialect differences

Both SQL and XML are file formats, so what differs below is how each one chooses to represent a value.

Property	in SQL	in XML
identifiers	Two competing conventions: single-quoted literals and diale...	Attribute values in quotes; entities (& < >) for ...
dates	Depends on the dialect: DATE literals, TO_DATE(), or plain ...	Text (xs:date / xs:dateTime when an XSD is in play)
binary	Dialect-specific: X-quoted literal, 0x hex, or decode()	base64Binary / hexBinary inside text
separator	Statement terminators (;)	Tags, not delimiters
encoding	No declaration	Declared in the XML declaration
typing	Types belong to the target database, and they differ betwee...	None in the markup itself
shape	Statements; a dump usually means CREATE TABLE plus INSERT rows	Arbitrary tree
ceiling	No formal limit, but a single INSERT statement has to fit i...	Whole document is usually parsed into memory

Convert SQL to XML the easy way

Use the SQL to XML converter — an offline desktop app for Windows, macOS and Linux. Nothing to upload, large files and batch runs supported (free trial).