Database DDL Sync in Jenkins

[Andrew Gray]

Hi All,

A question has come up here at work regarding how to handle DDL updates as part of the build.

My initial thought was that it would be handled in Visual Studio be enabling Database Migrations and therefore essentially be transparent to Jenkins.

Is there a any better way (a plugin I don't know about) to manage this in Jenkins?

Regards,

Andrew

[David Karlsen]

You can use http://flywaydb.org/ - it's not Jenkins specific (which is better IMHO) - but you can run it through Jenkins.

--
You received this message because you are subscribed to the Google Groups "Jenkins Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jenkinsci-de...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
--
David J. M. Karlsen - http://www.linkedin.com/in/davidkarlsen

[Andrew Gray]

Thanks David.

I imagine you have a flywaydb step as part of your build (after the clean and compile but before selenium test step) that picks up anything unprocessed in the "migrations" folder.

Would that be about right?

Thanks again.

Cheers,

Andrew

[David Karlsen]

Yes. That's how I do it. Or I have three jobs: building, deployment, testing.

Migration and dataload is part of the deployment job