Show version history on a table
It would be so helpful if there was some way to see the version history on an table, stored procedure, etc. With a team our size, we are often trying to look back and see who submitted a change to a table and why. We use a naming convention for our migrations that includes the user story id so just showing the migration script that caused the change would help so much.
Lee
shared this idea
If you are using Flyway Teams or Flyway Enterprise with SQL Server, Oracle, PostgreSQL, and/or MySQL, then we capture the model for all the objects in your database/schema on disk. This can be committed to your version control system so you have a history of every single change made to each object. Learn more at https://documentation.red-gate.com/fd/schema-model-138347045.html.
-
Lee
commented
I think this is close to what I was suggesting, but not quite what I meant. A table has a history associated to it through the version control system. In the comparison that you are explaining in the documentation linked above, it shows the differences in current & new. What I am asking for is the ability to see the history of that table and compare 2 version of that history. The same thing you can do in Visual Studio with 2 code files. You can select to compare the current version with a historical version or compare 2 historical versions. I would expect this to show like the comparison does now just with the 2 selected versions
