Name: SchemaR: How to cram a database into a repository
Start: 2024-09-27T11:15:00-0400
End: 2024-09-27T12:00:00-0400

Friday September 27, 2024 11:15am - 12:00pm EDT

Classroom 111

I would present a SDLC tool that we developed in-house. It's a CLI toolset that can reset a database schema and data in order to have a known set of data in a SQL Server database.

It uses a tool to generate data from SQL Server into "INSERT" scripts. It then uses them, along with the schema scripts from SQL Server, to build a database from scratch.

In my opinion, the most interesting part is how we were able to build the dependency tree. This tree allows us to reset data between E2E tests using the CLI. It deletes and re-inserts the specified tables and all ancestor tables (for better performance).

Speakers

David Mine

Software Architect, eParts Services

Friday September 27, 2024 11:15am - 12:00pm EDT
Classroom 111

Optimizing Team for Fast Flow

Attendees (2)

TechFest 2024

TechFest 2024

David Mine

Attendees (2)

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!