If you can script the SQL commands into a bash/batch script, then you should still be able to execute them. If you are using Oracle, there is also this plugin: https://wiki.jenkins-ci.org/display/JENKINS/SQLPlus+Script+Runner+Plugin
On Wednesday, August 3, 2016 at 10:28:26 AM UTC-4, Zue Sani wrote: > > Can we run sql scripts to deploy, which we have been using for manual > running of scripts???? > > On Sat, Jul 30, 2016 at 10:10 PM, suresh kumar <[email protected] > <javascript:>> wrote: > >> Hi Zue Sani, >> There are lot of Open Source and Commercial tools which provides options >> for migrating database sql scripts. >> Each having their own process to prepare scripts. >> Some of OpenSource tools and also having Jenkins plugins to migrate >> scripts. >> 1) Liquibase >> 2) Flyway >> >> Have a look at these official documentation and usage of Jenkins of their >> respective plugins. >> >> -Suresh >> >> On Saturday, July 30, 2016 at 7:44:46 PM UTC+5:30, Zue Sani wrote: >>> >>> hi, >>> >>> I had few questions on CD: >>> >>> >>> 1.) we are performing deployments manually using sql scripts. Can the >>> same scripts run on jenkins when we automate the deployment?. (I heard we >>> need to change them to dacpac scripts is that true?) >>> >>> >>> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "Jenkins Users" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/jenkinsci-users/JxJ-uIO-AD8/unsubscribe >> . >> To unsubscribe from this group and all its topics, send an email to >> [email protected] <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jenkinsci-users/36caa94b-539f-4880-a093-5519b0d9b601%40googlegroups.com >> >> <https://groups.google.com/d/msgid/jenkinsci-users/36caa94b-539f-4880-a093-5519b0d9b601%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "Jenkins Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/ca72ab93-ee8e-41dd-8153-5414ba2a0926%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
