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/CAGWsXCCw31FA_YQr06A_H4SkW%3DSgFKG6YjJrbxzr3jFWb0KOBw%40mail.gmail.com.
