Tutorials...Videos...Knowledge Base...And More............

Data Generation Fails When Check Constraints Are Violated.

When you generate data for a column that has a check constraint, the operation fails if data is generated that violates the constraint. To fix this problem, use the Range from and Range to properties to control how the data is generated.

For example, suppose that you have a table that has a column that are named StartDate, and a check constraint that requires StartDate to be after 2008. You can set the Range from property of the StartDate column to a value that is larger than 2008. You can see column check constraint in the notes field of the selected field.

Datanamic Data Generator will validate your settings before the data generation process starts and will notify you when the chance on a constraint violation is very high.

Back to Knowledge Base Datanamic Data Generator