In the third part of the continuous integration aka “CI” workflow, the Populate step will be described.
After the Build step is successfully finished, where a new database is built directly from latest changes in source control, the Populate step is initiated. In this step, non static tables in the newly built database from the source control repository will be populated with test data.
We already populated our static tables with data in the Build step. While extracting our objects we checked the setting “Include static data” that will pull all static data found in the repository and will load it into the tables created from object scripts.
For transactional tables, or tables that generally hold the bulk of the dynamic data in a database, the task is to populate those with automatically generated synthetic test data.
ApexSQL Generate is a tool that can populate SQL databases with test data using multiple generators for each column. It supports a full range of SQL data types and has an ability to recognize them in a loaded SQL database and provide real-world test data based on contained data types. It can generate: randomized test data using the Random generator and various options, and using the Regular expression generator, sequential data using the Incremental generator, and much more.
To follow the instructions to implement this step, read these articles:
In the next article, the fourth step of the CI workflow, the Test step, will be described.
A complete SQL Server CI/CD solution
© 2020 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité