I wasn't really advocating running SQL scripts manually or via script runner, but if you have the requirement, it can be done.
Since we are a java project, we use Flyway. On Thursday, August 11, 2016 at 9:40:39 AM UTC-4, Zue Sani wrote: > > one more quick fire: I had a script for CD. for example if I had 5 > successful builds... If I want to deploy build 4 , is the possible??? > > And could any let me know what is the best build and deployment scripts > for sql DB?? > > On Wed, Aug 10, 2016 at 10:24 AM, suresh kumar <[email protected] > <javascript:>> wrote: > >> Hi Jesse McCormick, >> Every time when deploying done manually updating the Jobs with sql >> scripts is not suggestible as this doesn't give full automation. As much as >> possible we have to eliminate manual tasks while achieving continuous >> deployment. >> >> -Suresh >> >> >> On Wednesday, August 3, 2016 at 8:55:33 PM UTC+5:30, Jesse McCormick >> wrote: >>> >>> 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]> >>>> 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]. >>>>> 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 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/25cc034e-da2a-4ad8-9e58-825750859d1a%40googlegroups.com >> >> <https://groups.google.com/d/msgid/jenkinsci-users/25cc034e-da2a-4ad8-9e58-825750859d1a%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/9141b630-ca15-4531-99de-15239b445500%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
