Thanks for the reply and information Chad. What I am trying to accomplish with the H2 console, is simply connect to my cruise.h2.db file. I haven't been able to do this yet. No, the migrator tool is not working as it will not connect to my cruise.h2.db file regardless of the fact that I have the userid and password to the database. I will try finding the appropriate version of the H2 console, as yes I would like to simply browse the database as a first step.
Thanks! Tim On Tuesday, September 6, 2022 at 10:11:38 PM UTC-7 Chad Wilson wrote: > So is the migrator tool working now without errors to migrate your data > into PostGres? > > Not sure what you are trying to achieve with the h2 console (and support > for this is really separate to anything GoCD related) but h2 versions have > very limited limited backward compatibility. They don't use semver. > > So your H2 DB from GoCD 20.4.0 and earlier won't be usable with h2 console > 2.x if this is the version you downloaded. it may also have issues with h2 > 1.4.x rather than 1.3.x. if you want/need to browse with the h2 console > you'll probably need to use the appropriate version for the database you're > trying to open. > > For wider context, the need for this forced db migration at GoCD 20.5.0 is > partly due to such H2 breaking changes in H2 1.4.200. since GoCD did a > migration in that version from H2 1.3 to 1.4 all GoCD H2 users are forced > to do this migration. > > To minimise number of manual migrations needed and give more flexibility > to users to switch away from H2 this was combined with an internal GoCD > switch to a different db deploy automation tool (dbdeploy -> liquibase) as > well as open sourcing and inlining into GoCD core the previously commercial > 'extension' support for running with non-H2 databases. The migrator tool > was written to support all of these breaking change migrations in one GoCD > upgrade. > > -Chad > > > On Wed, 7 Sep 2022, 05:58 Tim Stevens, <[email protected]> wrote: > >> Thank you for the suggestion to change from single to double quotes - >> that was part of the problem. Now, I am facing a different problem. Chad, >> the version of the migrator tool that I am using is 1.0.0. I also >> installed the H2 console application (can't tell you the version number) >> and in doing that, it created a test.mv.db file. The H2 console >> application was able to connect to that empty database just fine. The >> database that I have and am trying to convert to PostgersSQL in named >> cruise.h2.db. The H2 console application cannot connect to my database at >> all. It is throwing an error saying that the database C:\Users\Tim\cruise >> could not be found. I'm not sure why this is happening, or how to fix it, >> but I am past the driver issues I was having with the H2 database driver - >> I am thankful for that. >> >> Any advice would be greatly appreciated! >> >> On Monday, September 5, 2022 at 7:50:57 PM UTC-7 [email protected] wrote: >> >>> This may sound odd but can you try replacing the single quotes with >>> double quotes in the command you are executing in Windows. I think I >>> remember having to do that for the migration tool to work on Windows. >>> Thanks. >>> >>> Tsanko Stoev >>> >>> On Mon, Sep 5, 2022, 21:45 Chad Wilson <[email protected]> wrote: >>> >>>> Are you able to check you have the full zip/tgz unpacked in its >>>> original folders (scripts in bin/, jars in lib/ etc)? Something seems awry >>>> here, as if you don't have things in the folders that should be there. >>>> >>>> It's also be useful if you can confirm which specific version you are >>>> using from the GitHub releases? >>>> >>>> >>>> On Mon, 5 Sep 2022, 17:57 Tim Stevens, <[email protected]> wrote: >>>> >>>>> Windows Server 2022 Standard. >>>>> >>>>> On Monday, September 5, 2022 at 2:55:58 AM UTC-7 [email protected] >>>>> wrote: >>>>> >>>>>> What OS are you using? >>>>>> >>>>>> On Mon, 5 Sep, 2022, 15:01 Tim Stevens, <[email protected]> wrote: >>>>>> >>>>>>> Hi, thanks for the quick reply. I ran from the top level directory >>>>>>> and am getting this error now: >>>>>>> >>>>>>> Error: Could not find or load main class >>>>>>> com.thoughtworks.go.dbsync.cli.Main >>>>>>> Caused by: java.lang.ClassNotFoundException: >>>>>>> com.thoughtworks.go.dbsync.cli.Main >>>>>>> Press any key to continue . . . >>>>>>> >>>>>>> On Monday, September 5, 2022 at 2:16:53 AM UTC-7 >>>>>>> [email protected] wrote: >>>>>>> >>>>>>>> I see 2 issues: >>>>>>>> >>>>>>>> 1. You are probably running from the wrong directory. Run from the >>>>>>>> top level directory as bin/gocd-database-migrator >>>>>>>> 2. Your source db username/password may be wrong. The default H2 >>>>>>>> credentials are "sa", with a blank password >>>>>>>> >>>>>>>> >>>>>>>> On Mon, 5 Sep, 2022, 14:10 Tim Stevens, <[email protected]> wrote: >>>>>>>> >>>>>>>>> Sure Ketan I cannot get the tool to connect to my H2 database. I >>>>>>>>> am getting this error message when I try to run the tool: >>>>>>>>> >>>>>>>>> ERROR [main] DbSync:103 - null >>>>>>>>> java.sql.SQLException: Cannot load JDBC driver class >>>>>>>>> ''org.h2.Driver'' >>>>>>>>> at >>>>>>>>> org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:54) >>>>>>>>> at >>>>>>>>> org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:472) >>>>>>>>> at >>>>>>>>> org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:538) >>>>>>>>> at >>>>>>>>> org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:753) >>>>>>>>> at >>>>>>>>> com.thoughtworks.go.dbsync.Util.withDataSource(Util.java:95) >>>>>>>>> at com.thoughtworks.go.dbsync.DbSync.export(DbSync.java:77) >>>>>>>>> at com.thoughtworks.go.dbsync.cli.Main.main(Main.java:46) >>>>>>>>> Caused by: java.lang.ClassNotFoundException: 'org.h2.Driver' >>>>>>>>> at >>>>>>>>> java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(Unknown >>>>>>>>> Source) >>>>>>>>> at >>>>>>>>> java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(Unknown >>>>>>>>> >>>>>>>>> Source) >>>>>>>>> at java.base/java.lang.ClassLoader.loadClass(Unknown >>>>>>>>> Source) >>>>>>>>> at >>>>>>>>> org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:49) >>>>>>>>> ... 6 common frames omitted >>>>>>>>> java.lang.RuntimeException: java.sql.SQLException: Cannot load >>>>>>>>> JDBC driver class ''org.h2.Driver'' >>>>>>>>> at >>>>>>>>> com.thoughtworks.go.dbsync.Util.withDataSource(Util.java:104) >>>>>>>>> at com.thoughtworks.go.dbsync.DbSync.export(DbSync.java:77) >>>>>>>>> at com.thoughtworks.go.dbsync.cli.Main.main(Main.java:46) >>>>>>>>> Caused by: java.sql.SQLException: Cannot load JDBC driver class >>>>>>>>> ''org.h2.Driver'' >>>>>>>>> at >>>>>>>>> org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:54) >>>>>>>>> at >>>>>>>>> org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:472) >>>>>>>>> at >>>>>>>>> org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:538) >>>>>>>>> at >>>>>>>>> org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:753) >>>>>>>>> at >>>>>>>>> com.thoughtworks.go.dbsync.Util.withDataSource(Util.java:95) >>>>>>>>> ... 2 more >>>>>>>>> Caused by: java.lang.ClassNotFoundException: 'org.h2.Driver' >>>>>>>>> at >>>>>>>>> java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(Unknown >>>>>>>>> Source) >>>>>>>>> at >>>>>>>>> java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(Unknown >>>>>>>>> >>>>>>>>> Source) >>>>>>>>> at java.base/java.lang.ClassLoader.loadClass(Unknown >>>>>>>>> Source) >>>>>>>>> at >>>>>>>>> org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:49) >>>>>>>>> ... 6 more >>>>>>>>> >>>>>>>>> This is what I am using to run the tool from an elevated command >>>>>>>>> window: >>>>>>>>> >>>>>>>>> gocd-database-migrator --insert --progress >>>>>>>>> --source-db-url='jdbc:h2:/h2/cruise' >>>>>>>>> --source-db-driver-class='org.h2.Driver' --source-db-user='go' >>>>>>>>> --source-db-password='g0get!t' >>>>>>>>> --target-db-url='jdbc:postgresql://localhost:5432/cruise' >>>>>>>>> --target-db-driver-class='org.postgresql.Driver' >>>>>>>>> --target-db-user='postgres' --target-db-password='postgres' >>>>>>>>> >>>>>>>>> Thanks in advance for your help! >>>>>>>>> On Sunday, September 4, 2022 at 11:30:29 PM UTC-7 >>>>>>>>> [email protected] wrote: >>>>>>>>> >>>>>>>>>> Can you elaborate what issues you faced with the migrator tool? >>>>>>>>>> >>>>>>>>>> - Ketan >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Sat, Sep 3, 2022 at 4:39 PM Tim Stevens <[email protected]> >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>>> Hello all, still on GoCD 20.4.0. Has anyone successfully used >>>>>>>>>>> the gocd-database-migrator.1.0.0 tool? I have tried everything >>>>>>>>>>> that I know >>>>>>>>>>> to get it to run and I simply cannot. I would be interested to >>>>>>>>>>> know if >>>>>>>>>>> anyone has been able to use the tool successfully? >>>>>>>>>>> >>>>>>>>>>> On Sunday, August 28, 2022 at 6:16:50 AM UTC-7 Chad Wilson wrote: >>>>>>>>>>> >>>>>>>>>>>> Tim had already asked about upgrades in >>>>>>>>>>>> https://groups.google.com/g/go-cd/c/ugTXHPOXNoQ/m/tQ8ovKq8AQAJ >>>>>>>>>>>> and >>>>>>>>>>>> https://groups.google.com/g/go-cd/c/EuIqzYsl7mU/m/kkj8b_L3AwAJ >>>>>>>>>>>> - in May they were on 20.4.0, and I had suggested the best time to >>>>>>>>>>>> do a DB >>>>>>>>>>>> switch is probably during the 20.4.0 -> 20.5.0 upgrade since the >>>>>>>>>>>> use of >>>>>>>>>>>> that migrator tool is basically mandatory during that upgrade >>>>>>>>>>>> regardless of >>>>>>>>>>>> whether the plan is to stay on H2 or not (due to breaking change >>>>>>>>>>>> in H2 >>>>>>>>>>>> database version). >>>>>>>>>>>> >>>>>>>>>>>> But not sure if they have subsequently upgraded while keeping >>>>>>>>>>>> to H2 or not. I had assumed he had, but perhaps that was a >>>>>>>>>>>> mistake, so yeah >>>>>>>>>>>> - it would be useful to know. >>>>>>>>>>>> >>>>>>>>>>>> -Chad >>>>>>>>>>>> >>>>>>>>>>>> On Sun, Aug 28, 2022 at 8:42 PM Ketan Padegaonkar < >>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> What version of GoCD are you using? >>>>>>>>>>>>> >>>>>>>>>>>>> On Fri, 26 Aug, 2022, 22:55 Tim Stevens, <[email protected]> >>>>>>>>>>>>> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Hello, I have researched this question quite a bit, but am >>>>>>>>>>>>>> not finding anything that works. I would like to take the data >>>>>>>>>>>>>> in our GoCD >>>>>>>>>>>>>> H2 database and upload it/convert it to a PostgreSQL database. >>>>>>>>>>>>>> >>>>>>>>>>>>>> Any help would be appreciated! >>>>>>>>>>>>>> >>>>>>>>>>>>>> Tim >>>>>>>>>>>>>> >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>>>>> Google Groups "go-cd" 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/go-cd/ee37d34c-a591-4ce4-8e26-37fb39f4182an%40googlegroups.com >>>>>>>>>>>>>> >>>>>>>>>>>>>> <https://groups.google.com/d/msgid/go-cd/ee37d34c-a591-4ce4-8e26-37fb39f4182an%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>>> . >>>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>>>> Google Groups "go-cd" 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/go-cd/CAMUPJd6nZqdW_rjZ-MANh%3Dh_bRZEB7qZxxenbpfQOLDUjR%3DV1A%40mail.gmail.com >>>>>>>>>>>>> >>>>>>>>>>>>> <https://groups.google.com/d/msgid/go-cd/CAMUPJd6nZqdW_rjZ-MANh%3Dh_bRZEB7qZxxenbpfQOLDUjR%3DV1A%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>> . >>>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>> Google Groups "go-cd" 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/go-cd/ff1d45dc-b65d-4943-9426-18df58ad00ffn%40googlegroups.com >>>>>>>>>>> >>>>>>>>>>> <https://groups.google.com/d/msgid/go-cd/ff1d45dc-b65d-4943-9426-18df58ad00ffn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>>>> . >>>>>>>>>>> >>>>>>>>>> -- >>>>>>>>> You received this message because you are subscribed to the Google >>>>>>>>> Groups "go-cd" 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/go-cd/cb9b3591-2557-4e3d-9038-64ce67f92b77n%40googlegroups.com >>>>>>>>> >>>>>>>>> <https://groups.google.com/d/msgid/go-cd/cb9b3591-2557-4e3d-9038-64ce67f92b77n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>> . >>>>>>>>> >>>>>>>> -- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "go-cd" 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/go-cd/cde02eea-4c6e-40dd-bce8-389d31c3bbcen%40googlegroups.com >>>>>>> >>>>>>> <https://groups.google.com/d/msgid/go-cd/cde02eea-4c6e-40dd-bce8-389d31c3bbcen%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>> . >>>>>>> >>>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "go-cd" 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/go-cd/71adaff6-d9b5-4900-92e1-f44810be40dcn%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/go-cd/71adaff6-d9b5-4900-92e1-f44810be40dcn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "go-cd" 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/go-cd/CAA1RwH_E4uuFUGyCfgkANaT4VBhW%2BvhMxKD9D5xSJa%2BO9SR88Q%40mail.gmail.com >>>> >>>> <https://groups.google.com/d/msgid/go-cd/CAA1RwH_E4uuFUGyCfgkANaT4VBhW%2BvhMxKD9D5xSJa%2BO9SR88Q%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "go-cd" 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/go-cd/f0d25489-e6ec-4e86-9bce-f6f14ecc3e25n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/go-cd/f0d25489-e6ec-4e86-9bce-f6f14ecc3e25n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "go-cd" 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/go-cd/57e0d0b9-599b-4e3b-92cf-4a4eaed98484n%40googlegroups.com.
