Script Data Generator creates SQL INSERT statements from SQL Server tables, databases, and SSMS query results. It also exports selected result-grid cells as CSV, JSON, WHERE clause conditions, or custom text, and saves cell contents to files.

Save grid's cell data to file auto-recognizes most popular binary formats. The supported formats are:
PDF, DOCX, XLSX, PPTX, ZIP, DOC, XLS, PPT, JPEG, PNG, GIF, BMP, TIFF, WEBP, EXE, DLL.
If the cell data is not binary, it is saved as a .txt file.
You can save a single cell or all selected cells with each cell going into its own file.

Insert statements for the whole database are generated by the order of PK-FK relationships. Top tables with no FKs are scripted first. Binary data is by default fully scripted. If you wish you can also set the scripting data limit between 0 and 10 Mb. Larger values than the limit are then scripted as NULL. Insert statements for the data in result grids are scripted into a new temporary table for each grid or as a simple union all result set. For example from 5 result grids insert statements for 5 temporary tables get created.

Create a comma-separated values (CSV) list of selected values. The generated list can be grouped by rows or by columns. Values can also be scripted as ColumnName IN (Values) which can be inserted directly into a WHERE clause
You can also script only the selected cells' column names.

Create WHERE clause conditions of selected values. The scripted values have their data type preserved and ARE combined with AND conditions between columns and OR conditions between rows.

Create JSON-formatted data from selected values. Generated JSON is structurally equal to SQL Server's FOR JSON functionality.

Create a CUSTOM format export of selected cells. Separators between rows, columns and headers are all settable. For example, creating an HTML table from the data is very simple and is the CUSTOM formatter default.