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

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

Using DBBlobEditor, you can import bulk json 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
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

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

Run DBBlobEditor, login to SQL Server.

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

then show the wizard.

1. Configure import settings.

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

then you can see importing results

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.

FAQ

More about DBBlobEditor – JSON to SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) importer