[JIRA] (JENKINS-61830) Pipeline Maven Integration: migrate from H2 to MySQL/PostgreSQL

[apro.sebastian@gmail.com (JIRA)]

Sebastian Apro created an issue

Jenkins / JENKINS-61830 Pipeline Maven Integration: migrate from H2 to MySQL/PostgreSQL Issue Type: Task Assignee: Cyrille Le Clerc Components: h2-api-plugin, pipeline-maven-plugin Created: 2020-04-07 10:55 Environment: Pipeline Maven Integration 3.8.1 PipelineMavenPluginH2Dao - H2 1.4.199 Labels: pipeline-maven h2 Priority: Minor Reporter: Sebastian Apro Hi, We have been using the Pipeline Maven Integration plugin with the default H2 database for a while now and we are considering to switch to MySQL or PostgreSQL (as recommended). I've read the plugin wiki that describes how to configure it to use either MySQL or PostgreSQL but I could not find more information regarding how to actually migrate from H2. Does the data from the H2 database need to be migrated to the new database or can it be discarded? Would this affect the users in any way? Are there any other things to consider before switching to a new DB or can it be done "on the fly"? Any possible issues that might come up while/after the switch? Thanks and Best regards, Sebastian Add Comment

This message was sent by Atlassian Jira (v7.13.12#713012-sha1:6e07c38)

[apro.sebastian@gmail.com (JIRA)]

Sebastian Apro commented on JENKINS-61830

Re: Pipeline Maven Integration: migrate from H2 to MySQL/PostgreSQL I've switched from H2 to PostgreSQL. Maybe it will be useful for someone so, mentioning this here. Copied the data from H2 to PostgreSQL by exporting it as CSV using the H2 CSVWRITE command and then importing it using the COPY .., FROM PostgreSQL commands. I've had to disable all triggers before doing this due to the constraints and re-enabling them after the data was imported.

Add Comment

[apro.sebastian@gmail.com (JIRA)]

Sebastian Apro closed an issue as Done

Jenkins / JENKINS-61830

Pipeline Maven Integration: migrate from H2 to MySQL/PostgreSQL

Change By: Sebastian Apro Status: Open Closed Resolution: Done

Add Comment