DTM Data Generator Project Report

Summary

Report AttributeValue
Report Created27-Oct-2016 12:20
DTM Data Generator 2.00.11, Unicode, Enterprise
Project DescriptionSales DB1
Project AuthorMike and Ann
ConnectionSQL Server Native Client 11.0: .///NorthwindOld [Local Northwind DB]
Total Rules14
Prologue SQL Script--DBCC CHECKIDENT ('[AWBuildVersion]', RESEED, 0); <br>--DBCC CHECKIDENT ('[HumanResources].[Shift]', RESEED, 0);
Execution modeCreate output files only

Rule #1

Clear Rule, 13 table(s), top
Rule ItemDescription
Table: dbo.[Order Details]Clear Table
Table: dbo.ProductsClear Table
Table: dbo.OrdersClear Table
Table: dbo.EmployeeTerritoriesClear Table
Table: dbo.CustomerCustomerDemoClear Table
Table: dbo.TerritoriesClear Table
Table: dbo.SuppliersClear Table
Table: dbo.ShippersClear Table
Table: dbo.RegionClear Table
Table: dbo.EmployeesClear Table
Table: dbo.CustomersClear Table
Table: dbo.CustomerDemographicsClear Table
Table: dbo.CategoriesClear Table

Rule #2

Generator for 'dbo.Categories', append, top

Rows mode: records="50"

Transaction size: 500

Rule ItemData TypeDescription
Field: CategoryIDint identityIncremental: start with 1, step is 1, each value use 1 times, engine call: $Inc(1,1,,,1)
Field: CategoryNamenvarchar(15)From table ex2.ITEM [Access1/], engine call: $Table(ex2,ITEM,0,,Access1,,)
Field: DescriptionntextBy random data [1;4096], 10% nulls, engine call: $IfR(10,\NULL,$RString(1,4096,5,0,0))
Field: PictureimageBy random data [1;4096], 10% nulls, engine call: 0xX{1:8190}

Rule #3

Generator for 'dbo.CustomerDemographics', append, top

Rows mode: records="50"

Transaction size: 500

Rule ItemData TypeDescription
Field: CustomerTypeIDnchar(10)By random data [1;10], Unique, engine call: $Unique($RString(1,10,5,0,0))
Field: CustomerDescntextBy random data [1;4096], 10% nulls, engine call: $IfR(10,\NULL,$RString(1,4096,5,0,0))

Rule #4

Generator for 'dbo.Customers', append, top

Rows mode: records="50"

Transaction size: 500

Rule ItemData TypeDescription
Field: CustomerIDnchar(5)By random data [1;5], Unique, engine call: $Unique($RString(1,5,5,0,0))
Field: CompanyNamenvarchar(40)From Value Library [Companies], engine call: $Lib(Companies,Name,40,0)
Field: ContactNamenvarchar(30)By random data [1;30], 10% nulls, engine call: $IfR(10,\NULL,$RString(1,30,5,0,0))
Field: ContactTitlenvarchar(30)By random data [1;30], 10% nulls, engine call: $IfR(10,\NULL,$RString(1,30,5,0,0))
Field: Addressnvarchar(60)By pattern 'N{4} $Lib(Streets)', 10% nulls
Field: Citynvarchar(15)From Value Library [Cities], 10% nulls, engine call: $IfR(10,\NULL,$Lib(Cities,Name,15,0))
Field: Regionnvarchar(15)From Value Library [Region], 10% nulls, engine call: $IfR(10,\NULL,$Lib(Region,Name,15,0))
Field: PostalCodenvarchar(10)By pattern 'NNNNN', 10% nulls
Field: Countrynvarchar(15)From Value Library [Countries], 10% nulls, engine call: $IfR(10,\NULL,$Lib(Countries,Name,15,0))
Field: Phonenvarchar(24)By pattern '\(NNN\) NNN-NNNN', 10% nulls
Field: Faxnvarchar(24)By pattern '\(NNN\) NNN-NNNN', 10% nulls

Rule #5

Generator for 'dbo.Employees', append, top

Rows mode: records="50"

Transaction size: 500

Rule ItemData TypeDescription
Field: EmployeeIDint identityIgnore
Field: LastNamenvarchar(20)From Value Library [LastNames], engine call: $Lib(LastNames,Name,20,0)
Field: FirstNamenvarchar(10)From Value Library [FirstNames], engine call: $Lib(FirstNames,Name,10,0)
Field: Titlenvarchar(30)By random data [1;30], 10% nulls, engine call: $IfR(10,\NULL,$RString(1,30,5,0,0))
Field: TitleOfCourtesynvarchar(25)By random data [1;25], 10% nulls, engine call: $IfR(10,\NULL,$RString(1,25,5,0,0))
Field: BirthDatedatetimeBy random data [1950-01-01;2020-12-31], 10% nulls, engine call: $RDate(YYYY-MM-DD,1950-01-01,2020-12-31) $RTime(HH:MM:SS)
Field: HireDatedatetimeBy random data [1950-01-01;2020-12-31], 10% nulls, engine call: $RDate(YYYY-MM-DD,1950-01-01,2020-12-31) $RTime(HH:MM:SS)
Field: Addressnvarchar(60)By pattern 'N{4} $Lib(Streets)', 10% nulls
Field: Citynvarchar(15)From Value Library [Cities], 10% nulls, engine call: $IfR(10,\NULL,$Lib(Cities,Name,15,0))
Field: Regionnvarchar(15)From Value Library [Region], 10% nulls, engine call: $IfR(10,\NULL,$Lib(Region,Name,15,0))
Field: PostalCodenvarchar(10)By pattern 'NNNNN', 10% nulls
Field: Countrynvarchar(15)From Value Library [Countries], 10% nulls, engine call: $IfR(10,\NULL,$Lib(Countries,Name,15,0))
Field: HomePhonenvarchar(24)By pattern '\(NNN\) NNN-NNNN', 10% nulls
Field: Extensionnvarchar(4)By random data [1;4], 10% nulls, engine call: $IfR(10,\NULL,$RString(1,4,5,0,0))
Field: PhotoimageBy random data [1;4096], 10% nulls, engine call: 0xX{1:8190}
Field: NotesntextBy random data [1;4096], 10% nulls, engine call: $IfR(10,\NULL,$RString(1,4096,5,0,0))
Field: ReportsTointFrom table dbo.Employees.EmployeeID, 10% nulls, engine call: $IfR(10,\NULL,$Table(dbo.Employees,EmployeeID,0))
Field: PhotoPathnvarchar(255)By random data [1;255], 10% nulls, engine call: $IfR(10,\NULL,$RString(1,255,5,0,0))

Rule #6

Generator for 'dbo.Region', append, top

Rows mode: records="50"

Transaction size: 500

Rule ItemData TypeDescription
Field: RegionIDintBy random data, Unique, engine call: $Unique($Rint(,,))
Field: RegionDescriptionnchar(50)From Value Library [Region], engine call: $Lib(Region,Name,50,0)

Rule #7

Generator for 'dbo.Shippers', append, top

Rows mode: records="50"

Transaction size: 500

Rule ItemData TypeDescription
Field: ShipperIDint identityIgnore
Field: CompanyNamenvarchar(40)From Value Library [Companies], engine call: $Lib(Companies,Name,40,0)
Field: Phonenvarchar(24)By pattern '\(NNN\) NNN-NNNN', 10% nulls

Rule #8

Generator for 'dbo.Suppliers', append, top

Rows mode: records="50"

Transaction size: 500

Rule ItemData TypeDescription
Field: SupplierIDint identityIgnore
Field: CompanyNamenvarchar(40)From Value Library [Companies], engine call: $Lib(Companies,Name,40,0)
Field: ContactNamenvarchar(30)By random data [1;30], 10% nulls, engine call: $IfR(10,\NULL,$RString(1,30,5,0,0))
Field: ContactTitlenvarchar(30)By random data [1;30], 10% nulls, engine call: $IfR(10,\NULL,$RString(1,30,5,0,0))
Field: Addressnvarchar(60)By pattern 'N{4} $Lib(Streets)', 10% nulls
Field: Citynvarchar(15)From Value Library [Cities], 10% nulls, engine call: $IfR(10,\NULL,$Lib(Cities,Name,15,0))
Field: Regionnvarchar(15)From Value Library [Region], 10% nulls, engine call: $IfR(10,\NULL,$Lib(Region,Name,15,0))
Field: PostalCodenvarchar(10)By pattern 'NNNNN', 10% nulls
Field: Countrynvarchar(15)From Value Library [Countries], 10% nulls, engine call: $IfR(10,\NULL,$Lib(Countries,Name,15,0))
Field: Phonenvarchar(24)By pattern '\(NNN\) NNN-NNNN', 10% nulls
Field: Faxnvarchar(24)By pattern '\(NNN\) NNN-NNNN', 10% nulls
Field: HomePagentextBy pattern 'www.aa{8}.com', 10% nulls

Rule #9

Generator for 'dbo.Territories', append, top

Rows mode: records="50"

Transaction size: 500

Rule ItemData TypeDescription
Field: TerritoryIDnvarchar(20)By random data [1;20], Unique, engine call: $Unique($RString(1,20,5,0,0))
Field: TerritoryDescriptionnchar(50)By random data [1;50], engine call: $RString(1,50,5,0,0)
Field: RegionIDintFrom table dbo.Region.RegionID, engine call: $Table(dbo.Region,RegionID,0)

Rule #10

Generator for 'dbo.CustomerCustomerDemo', append, top

Rows mode: records="50"

Transaction size: 500

Rule ItemData TypeDescription
Field: CustomerIDnchar(5)From table dbo.Customers.CustomerID, engine call: $Table(dbo.Customers,CustomerID,0)
Field: CustomerTypeIDnchar(10)From table dbo.CustomerDemographics.CustomerTypeID, engine call: $Table(dbo.CustomerDemographics,CustomerTypeID,0)

Rule #11

Generator for 'dbo.EmployeeTerritories', append, top

Rows mode: records="50"

Transaction size: 500

Rule ItemData TypeDescription
Field: EmployeeIDintFrom table dbo.Employees.EmployeeID, engine call: $Table(dbo.Employees,EmployeeID,0)
Field: TerritoryIDnvarchar(20)From table dbo.Territories.TerritoryID, engine call: $Table(dbo.Territories,TerritoryID,0)

Rule #12

Generator for 'dbo.Orders', append, top

Rows mode: records="50"

Transaction size: 500

Rule ItemData TypeDescription
Field: OrderIDint identityIgnore
Field: CustomerIDnchar(5)From table dbo.Customers.CustomerID, 10% nulls, engine call: $IfR(10,\NULL,$Table(dbo.Customers,CustomerID,0))
Field: EmployeeIDintFrom table dbo.Employees.EmployeeID, 10% nulls, engine call: $IfR(10,\NULL,$Table(dbo.Employees,EmployeeID,0))
Field: OrderDatedatetimeBy random data [1950-01-01;2020-12-31], 10% nulls, engine call: $RDate(YYYY-MM-DD,1950-01-01,2020-12-31) $RTime(HH:MM:SS)
Field: RequiredDatedatetimeBy random data [1950-01-01;2020-12-31], 10% nulls, engine call: $RDate(YYYY-MM-DD,1950-01-01,2020-12-31) $RTime(HH:MM:SS)
Field: ShippedDatedatetimeBy random data [1950-01-01;2020-12-31], 10% nulls, engine call: $RDate(YYYY-MM-DD,1950-01-01,2020-12-31) $RTime(HH:MM:SS)
Field: ShipViaintFrom table dbo.Shippers.ShipperID, 10% nulls, engine call: $IfR(10,\NULL,$Table(dbo.Shippers,ShipperID,0))
Field: Freightmoney(19,4)By random data, format '%19.4f', 10% nulls, engine call: $IfR(10,\NULL,$Rfloat(,,4,%19.4f))
Field: ShipNamenvarchar(40)By random data [1;40], 10% nulls, engine call: $IfR(10,\NULL,$RString(1,40,5,0,0))
Field: ShipAddressnvarchar(60)By pattern 'N{4} $Lib(Streets)', 10% nulls
Field: ShipCitynvarchar(15)From Value Library [Cities], 10% nulls, engine call: $IfR(10,\NULL,$Lib(Cities,Name,15,0))
Field: ShipRegionnvarchar(15)From Value Library [Region], 10% nulls, engine call: $IfR(10,\NULL,$Lib(Region,Name,15,0))
Field: ShipPostalCodenvarchar(10)By pattern 'NNNNN', 10% nulls
Field: ShipCountrynvarchar(15)From Value Library [Countries], 10% nulls, engine call: $IfR(10,\NULL,$Lib(Countries,Name,15,0))

Rule #13

Generator for 'dbo.Products', append, top

Rows mode: records="50"

Transaction size: 500

Rule ItemData TypeDescription
Field: ProductIDint identityIgnore
Field: ProductNamenvarchar(40)By random data [1;40], engine call: $RString(1,40,5,0,0)
Field: SupplierIDintFrom table Table1.F1 [TestAccess/], 10% nulls, engine call: $IfR(10,\NULL,$Table(Table1,F1,0,,TestAccess,,))
Field: CategoryIDintFrom table dbo.Categories.CategoryID, 10% nulls, engine call: $IfR(10,\NULL,$Table(dbo.Categories,CategoryID,0))
Field: QuantityPerUnitnvarchar(20)By random data [1;20], 10% nulls, engine call: $IfR(10,\NULL,$RString(1,20,5,0,0))
Field: UnitPricemoney(19,4)By random data, format '%19.4f', 10% nulls, engine call: $IfR(10,\NULL,$Rfloat(,,4,%19.4f))
Field: UnitsInStocksmallintBy random data [;32766], format '%d', 10% nulls, engine call: $IfR(10,\NULL,$Rint(,32766,%d))
Field: UnitsOnOrdersmallintBy random data [;32766], format '%d', 10% nulls, engine call: $IfR(10,\NULL,$Rint(,32766,%d))
Field: ReorderLevelsmallintBy random data [;32766], format '%d', 10% nulls, engine call: $IfR(10,\NULL,$Rint(,32766,%d))
Field: DiscontinuedbitBy random data [;1], format '%d', engine call: $Rint(,1,%d)

Rule #14

Generator for 'dbo.[Order Details]', append, top

Rows mode: records="50"

Transaction size: 500

Rule ItemData TypeDescription
Field: OrderIDintFrom table dbo.Orders.OrderID, engine call: $Table(dbo.Orders,OrderID,0)
Field: ProductIDintFrom table dbo.Products.ProductID, engine call: $Table(dbo.Products,ProductID,0)
Field: UnitPricemoney(19,4)By random data, format '%19.4f', engine call: $Rfloat(,,4,%19.4f)
Field: QuantitysmallintBy pattern '$$($Vars(@V2TO10)*$Vars(@V2TO10))'
Field: DiscountrealBy random data [0;1], format '%f', engine call: $Rfloat(0,1,3,%f)

Named Generators

Generator NameDescription
CATEGORYBy random data [1;15]
DESCRIPTIONSBy random data [1;4096], 10% nulls
IMAGESBy random data [1;4096], 10% nulls

Variables

Variable NameDescription
#FROMConstant = 10
#TOConstant = 50
#STEPConstant = 3
@V2TO10Pattern = $Rint(2,10)
>IMAGESBy random data [1;4096], 10% nulls

Variables

Variable NameDescription
#FROMConstant = 10
#TOConstant = 50
#STEPConstant = 3
@V2TO10Pattern = $Rint(2,10)