SQL Server 16.0.4295.3
AdventureWorksLT
Product sales, customers and orders. Pick a table to see the source and the synthetic copy together.
- Tables
- 12
- Rows, source
- 4,277
- Rows, synthetic
- 4,277
- Broken foreign keys
- 0 12 foreign keys checked on the data
The profile
Lyrebird read the source once and wrote this profile. The synthetic database was generated from the profile alone, with no connection to the source.
- Profile file
- 182 KB
- Relationships measured
- 12
- Rules tested / kept
- 800 / 11
- Personal columns found
- 17
- Tables with reference data
- 3
Generate it yourself
This is the same sealed profile that produced the copy on these pages. It holds no connection details, and you need no database to use it.
Download lyrebird-sample-adventureworks-lt.lyre- Install Lyrebird Community, open it and go to Generate.
- Choose the downloaded file as the profile, then choose an output folder.
- Generate the SQL files, and load them into an empty SQL Server database or let Lyrebird load them into Docker.
Community generates up to 5,000 rows per table and keeps complete reference data as it is. Every table of this sample fits within that limit.
Lyrebird Community 0.4.0
This release on GitHub182 KB · SHA-256 c79bbec4cd704a679f1b5ce621324e25d30acfe6daabbc3a28624e4f698428e9
Tables
| Table | Columns | Source rows | Synthetic rows | Equal to a source row |
|---|---|---|---|---|
| SalesLT.Address | 9 | 450 | 450 | 0% |
| SalesLT.CustomerAddress | 5 | 417 | 417 | 0% |
| SalesLT.Customer | 15 | 847 | 847 | 0% |
| SalesLT.ProductCategory | 5 | 41 | 41 | 100% |
| SalesLT.ProductDescription | 4 | 762 | 762 | 0% |
| SalesLT.ProductModelProductDescription | 5 | 762 | 762 | 0% |
| SalesLT.ProductModel | 5 | 128 | 128 | 28.9% |
| SalesLT.Product | 17 | 295 | 295 | 0% |
| SalesLT.SalesOrderDetail | 9 | 542 | 542 | 0% |
| SalesLT.SalesOrderHeader | 22 | 32 | 32 | 0% |
| dbo.BuildVersion | 4 | 1 | 1 | Keys only |
| dbo.ErrorLog | 9 | 0 | 0 | Keys only |
About this data
AdventureWorksLT2022, Microsoft SQL Server Sample Code, copyright (c) Microsoft Corporation. Source: AdventureWorksLT, MIT license. Subsetra is not affiliated with its authors.
Lyrebird refuses SQL Server XML indexes, indexed views and XML schema collections on columns, and reports them. We removed one XML index and one indexed view from our copy of AdventureWorksLT2022, and made one XML column untyped, before profiling. Every table, column and row stayed.
Generated with Lyrebird 0.4.0 (af70e35), model v2.3, seed 20261101, at the size of the source. Profile hash: f9da934075761509.