SQL Server test data, IDENTITY and all.

Get realistic, relationally consistent test data for Microsoft SQL Server from your schema or a plain-English description, delivered as a single T-SQL script.

Generate data free How we compare

Free trial for every new account. No credit card.

online_store_sqlserver.sql

-- ============================================================
-- Synthetic dataset : online_store
-- Dialect           : SQL Server
-- Contents          : 3 table(s), 25,000 row(s)
-- Load with         : sqlcmd -S your_server -d your_database -i this_file.sql
SET XACT_ABORT ON;
BEGIN TRANSACTION;
SET IDENTITY_INSERT [customers] ON;
INSERT INTO [customers] ([id], [name], [email], [city]) VALUES
    (1042, 'Priya Nair', 'priya.nair@example.com', 'Pune'),
    (1043, N'José Álvarez', 'jose.alvarez@example.com', N'Málaga');
SET IDENTITY_INSERT [customers] OFF;
COMMIT TRANSACTION;

Sample output, shortened. Your file contains every table and row you asked for.

Why teams use it

Built for data that behaves like production

IDENTITY columns handled

Generated keys are inserted with IDENTITY_INSERT, so relationships stay intact and your app keeps inserting afterwards.

Unicode-safe text

Text with accents or non-Latin characters is written as N'' Unicode literals, so it survives the load unchanged.

Foreign keys that resolve

Tables are filled in dependency order, so every foreign key references a real parent row.

One transaction

XACT_ABORT plus a single transaction: the script loads completely or leaves your database as it was.

Realistic business data

Customers, orders, invoices, employees and more, with values and proportions that look like a real system.

Structure only

We read your schema, never your data. Uploaded data rows are stripped before processing.

How it works

From schema to dataset in three steps

Describe or upload

Describe your data in plain English, or upload your SQL schema for PostgreSQL, MySQL / MariaDB, SQL Server and SQLite.

Review the plan

Check the tables, columns and rules the AI proposes, and adjust anything you like.

Generate and download

Choose how many rows you need and download a ready-to-run SQL script, CSV, Excel (one sheet per table) or JSON.

Questions

Does it work with Azure SQL?

The output is standard T-SQL, so it can be run against Azure SQL Database as well as on-premises SQL Server.

Can I keep my own table definitions?

Yes. When you upload SQL Server DDL, your own CREATE TABLE statements are kept in the output.

What about very large tables?

Rows are written in batches. Generate the size your plan allows and load as usual.

Is there a free option?

Yes. Every new account gets a free trial to generate real datasets before buying a plan.