Hi Peter; If you find a solution, please respond here. I am really struggling................ that may be because of my knowledge of H2 database commands.
Thanks. On Friday, 27 July 2012 13:36:12 UTC+1, Peter Dahm wrote: > > Hi, > > what about linked tables ? > > We have the same problem and at this point I'm trying to copy between the > databases with a H2 in Memory instance to link to database instances and > copy via insert into ... select from... > > Up to know it works OK > > Does someone has experiences with this approach or is there any reason > not to do it in this way ? > > Peter > > On Friday, July 27, 2012, Thomas Mueller wrote: > >> Hi, >> >> I heard a good way to copy data to / from different databases is to >> use one of the tools listed at: >> >> http://h2database.com/html/links.html#tools >> >> Specially the "SQuirreL DB Copy Plugin" or the "Flyway". >> >> Regards, >> Thomas >> >> >> >> On Thu, Jul 26, 2012 at 6:36 PM, Tariq Mehmood <[email protected]> >> wrote: >> > Hi All, >> > I am trying to copy database tables from H2 to mySql in RedHat. I have >> no >> > experience with H2 and some experience with mySql. >> > I have already created empty database tables in mySql exactly same as >> they >> > exist in H2. >> > Now the challenge is to copy all the data from tables in H2 database to >> > mySql in a less painful way. >> > Would you be kind enough to point me to the right direction that how >> should >> > i approach this. >> > Any help is appriciated. >> > And Thanks in advance for your help. >> > >> > Best Regards, >> > Tariq >> > >> > -- >> > You received this message because you are subscribed to the Google >> Groups >> > "H2 Database" group. >> > To view this discussion on the web visit >> > https://groups.google.com/d/msg/h2-database/-/WTuXQgYzTe8J. >> > To post to this group, send email to [email protected]. >> > To unsubscribe from this group, send email to >> > [email protected]. >> > For more options, visit this group at >> > http://groups.google.com/group/h2-database?hl=en. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/h2-database?hl=en. >> >> -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/4hs5g_BOmtkJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
