regarding jenkins CD in jenkins 2.0

[Zue Sani]

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?)

[suresh kumar]

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

[Zue Sani]

Can we run sql scripts to deploy, which we have been using for manual running of scripts????

--
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 jenkinsci-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/36caa94b-539f-4880-a093-5519b0d9b601%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Jesse McCormick]

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

[suresh kumar]

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

[Zue Sani]

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?? 

To unsubscribe from this group and all its topics, send an email to jenkinsci-users+unsubscribe@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/25cc034e-da2a-4ad8-9e58-825750859d1a%40googlegroups.com.

[Jesse McCormick]

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.

[Zue Sani]

Hi,

I had setup windows slave using java web start setup. and I tried downloaded the jnlp file and tried to run on the jenkins master. It says cannot connect to application. (connection refused).

Could you please help me with this.

To unsubscribe from this group and all its topics, send an email to jenkinsci-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/9141b630-ca15-4531-99de-15239b445500%40googlegroups.com.

[Zue Sani]

This is when I tried wiith "LET JENKINS CONTROL THIS WINDOWS SLAVE AS A WINDOWS SERVICE".

Help would be appreciated.