JSON in RDBMS
Microsoft SQL Server
and Azure SQL Database
SQL is aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users
Hackolade has the unique ability to model complex semi-structured objects stored in columns of the (N)VARCHAR(MAX) data type. The reverse-engineering function, if it detects JSON documents, will sample records and infer the schema to supplement the DDL table definitions.
Hackolade was specially adapted to support the data modeling of SQL Server and Azure SQL Database, including schemas, tables and views, indexes and constraints, plus the generation of DDL Create Table syntax.