Batch import JSON files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) without programming

by

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, just a few mouse clicks.

Here you can download and install DBBlobEditor.

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

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

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

then show the wizard.

1. Config.

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

2. Import.

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

then you can see importing results

Batch import json 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 JSON documents to SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) column

30-day free trial Download DBBlobEditor