Re: Copy Tables from H2 to mySQL

[Thomas Mueller]

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 <tari...@gmail.com> 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 h2-da...@googlegroups.com.
> To unsubscribe from this group, send email to
> h2-database...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.

[Peter Dahm]

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

[Tariq Mehmood]

Thanks Thomas, will try now...................

> h2-database+unsubscribe@googlegroups.com.

[Tariq Mehmood]

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.

> h2-database+unsubscribe@googlegroups.com.

> 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 h2-da...@googlegroups.com.

To unsubscribe from this group, send email to h2-database+unsubscribe@googlegroups.com.