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]<javascript:;>> > 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]<javascript:;> > . > > To unsubscribe from this group, send email to > > [email protected] <javascript:;>. > > 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]<javascript:;> > . > To unsubscribe from this group, send email to > [email protected] <javascript:;>. > 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.
