SQL Data Generator 4

SQL Server 2025 Data Type Generation Notes

In SQL Data Generator, two behaviors have been observed when working with SQL Server 2025 databases that include newly supported data types like VECTOR and JSON.

VECTOR and JSON Generators Listed Under Generic

Although VECTOR and JSON are valid SQL Server 2025 data types, their generators may not appear under the SQL Type Generation category. Instead, they are listed in the Generic section.

This is a classification behavior only and does not affect the ability to assign generators.

VECTOR Generator Not Supported When a Vector Index Exists

If a VECTOR index is defined on a column, the VECTOR generator may not function as expected. This is due to a known SQL Server 2025 limitation related to Vector Index constraints, as detailed in Microsoft's documentation.

This affects data generation for those specific columns but does not impact other generator types.



Didn't find what you were looking for?