Data Management Challenge - Bob Salmon using SQLServer Studio and Visual Studio

Summary

Bob Salmon solves the Data Management Challenge from Test.bash(); 2022 using SQLServer Studio and Visual Studio.

There are lots of tools out there that we can use to create or fake test data. That’s why in this challenge we want to see demonstrations of tools that allow us to set up test data for testing purposes. We’d like to see how far you got with solving the challenge, what you liked about the tooling you used, and what you disliked.

Instructions

Using a tool of your choice that you think the community would be interested in, show us how you would mitigate the following problem:

Creating test data manually is taking too long and slowing the team down

If you had to rapidly create test data in an environment, how would you do it? Would you use an existing tool or build your own?

Example:

One example of mitigating this risk might be to find:

1. Find the seed.sql files in the github.com/mwinteringham/restful-booker-platform project
2. Duplicate the INSERT SQL statement multiple times and then build the application to get it running with lots of new test data

Tip: You’ll find more opportunities to manage test data if you have restful-booker-platform running locally on your machine.

Also, check out the Postman collection for Restful-Booker-Platform to get started with its APIs Postman

Follow

Bob Salmon

Senior Software Engineer

I'm a programmer who likes people, code and data. That means I think that things like quality and user experience are important too.