How can we help you today? How can we help you today?
seppe
Activity overview Badges (0) Posts (1) Comments (1)

Activity overview

Latest activity by seppe

Hi Peter, Thanks for the reply. I'll have a look to see if DDL / grouped transactions speed things up. In the meantime I think I figured out running the full set of migrations isn't really required, as Flyway does a pretty good job at finding migrations that changed based on the hashes. This means I can run migrations on a Docker container, commit the changes to a docker image and push that image to a repo. CI can then run the migrations with that image running as a service. In a perfect world, I would then be able to commit the changes applied to the DB image in CI, but I haven't figured out how/if this is possible (probably it is with DIND an Docker compose). The only potential issue that this approach doesn't catch is that some migrations might use stored procedures, which in the codebases I work on are typically created in repeatable migrations. Would there be an easy way (i.e without having to specify the last migration version to apply) to only run the migrations up to, but not including, the repeatable migrations? This way a docker image that does not have any repeatable migrations could be created. This image could then be used to ensure the versioned migrations do not depend on any repeatable migrations. As an added benefit of this approach, I'll have versioned Docker images so I can quickly set up dev DB instances for a specific version. The biggest downside is that the DB image needs users set up, so I have to deal with managing those credentials. Any ideas on how to disable or easily alter the DB credentials? On a somewhat related not, I have been looking into ways to get more out of running migrations in CI like creating ER Diagrams. Are there any solutions that are useful for this? In a (distant) past I used Navicat to generate ERDs and I would commit them in the SCM. This was 10+ years ago, are there better ways to auto-generate DB documentation? / comments
  1. Community
  2. Flyway (General Discussion)
  3. Optimize SQL server to test migrations
Hi Peter,Thanks for the reply. I'll have a look to see if DDL / grouped transactions speed things up.In the meantime I think I figured out running the full set of migrations isn't really required, ...
0 votes
Optimize SQL server to test migrations
  1. Community
  2. Flyway (General Discussion)
We use Flyway for DB migrations (using the Java API) on SQL Server of an old project, meaning a lot of migrations accumulated over time. This makes testing the migrations rather tedious, as running...
2 followers 3 comments 0 votes
Total activity
3
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1