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

Convert SQL to XML

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

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

convert SQL file to XML file - task window

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

create XML file by SQL file - select type

1. Open source SQL file.

Support large SQL file ( > 4GB ).

transform SQL file to XML file - open a SQL file

Source SQL file’s content is like this:

SQL to XML converter - source SQL file

2. Config target XML file.

generate XML file by SQL file - config XML file

3. Set rows options.

convert SQL file to XML file - summary

4. Convert SQL to XML.

convert SQL file to XML file - convert file

After converting, you can view the output XML file.

convert SQL file to XML file - view XML file

More about SQL to XML converter

Download Withdata DataFileConverter

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

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 & <)`
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).