Batch import xml files into SQL Server TEXT / NTEXT / VARCHAR(MAX) / NVARCHAR(MAX)

by

Posted on by

Want to batch import XML documents into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) or [IMAGE, VARBINARY(MAX)] (BLOB) column?

Using DBBlobEditor, you can import bulk xml files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) or [IMAGE, VARBINARY(MAX)] (BLOB) easily and fast.

  • Step by step, just a few mouse clicks.
  • Support schedule and automate converting task.
  • Support Windows, Linux, macOS.

Download DBBlobEditor Download DBBlobEditor

Batch import XML documents to SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) column

Run DBBlobEditor, login to SQL Server.

Batch import xml files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) - login to SQL Server

Click “Start New Task – Import LOB From Files” at task dialog.

Batch import xml files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) - Task Window

then show the wizard.

1. Configure import settings.

Batch insert xml files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) - config

2. Bulk import XML files to SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB).

Batch save xml files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) - import

then you can see importing results

Batch import xml files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) - view

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.

More about DBBlobEditor – the tool to batch import XML documents to SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) column

30-day free trial Download DBBlobEditor