Source Controlled Database Data import strategies.
- by H. Abraham Chavez
So I've gotten a project and got the db team sold on source control for the db (weird right?) anyway, the db already exists, it is massive, and the application is very dependent on the data. The developers need up to three different flavors of the data to work against when writing SPROCs and so on.
Obviously I could script out data inserts.
But my question is what tools or strategies do you use to build a db from source control and populate it with multiple large sets of data?