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.
