Batch import JSON 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) column?

Try Withdata DBBlobEditor, a SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) editor, Bulk import JSON into SQL Server, East and Fast.

• Can run in GUI mode, just a few mouse clicks.
• Can run in Command line, for Scheduled Tasks and Streams.
• Support Windows, Linux, and 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 JSON settings.

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

then you can see importing results

---

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

JSON → SQL Server reference

Type mapping

Value kind	in JSON	in SQL Server
Int	1234 (number)	int
Bigint	9007199254740993	bigint
Decimal	1234.56 (number)	decimal(p,s)
Float	1.234e10 (number)	float
Text	"text" (string)	nvarchar(n)
Long text	"multi-line\ntext" (escaped newline inside a string)	nvarchar(max)
Date	"2026-09-18" (string)	date
Datetime	"2026-09-18T14:30:00Z" (string)	datetime2
Binary	"base64:..." (string)	varbinary(max)
Boolean	true / false (boolean)	bit
JSON	nested object or array, kept as structure	nvarchar(max)

Dialect differences

JSON is a file format and SQL Server is a database server, so the target has to be told the types the file never carried - the rows below are where the two sides diverge.

Property	in JSON	in SQL Server
port	—	1433
identifiers	Double quotes; backslash escapes	[square brackets]
row limit	—	SELECT TOP n
dates	No date type: dates arrive as strings and the reader must p...	datetime, datetime2, date, time
long text	—	nvarchar(max)
binary	Not supported natively - base64 inside a string	varbinary(max)
separator	Braces and commas	—
encoding	UTF-8 by definition	—
typing	string, number, boolean, null, object, array - no date type	—
shape	Nested objects and arrays	Tables of rows and columns
ceiling	Whole document is usually parsed into memory	—

Command line

Side	Command
SQL Server	bcp
SQL Server (load)	bcp, or BULK INSERT

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.