Using mybatis to move data from db to another

[yaog]

I have a use case where I need to move data from one DB to another. Db's could be different products (i.e. move from Oracle to MySql).

I saw an old apache lib that is not maintained anymore (ddlutils) and I am wondering if mybatis can assist me here somehow.

Any ideas?

[Guy Rouillier]

MyBatis has a Migrations tool: http://www.mybatis.org/migrations/

But I've never used it.  I already had a tool which assisted in moving data between different databases, and find it fast and easy to use: Sql Workbench/J: https://www.sql-workbench.eu/

Check out Data Pumper on the Tools menu.

--

Guy Rouillier

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mybatis-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/eaf23a41-0731-4ac7-adbc-71a1b8778440%40googlegroups.com.

[Yair Ogen]

Thanks. I don't see java based examples usages in that site. Also  - didn't find any maven or other binary repo information. Does it support usage from within Java?

You received this message because you are subscribed to a topic in the Google Groups "mybatis-user" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mybatis-user/94GbyJHcBHk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mybatis-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/embcd88c80-78e9-46d3-82f6-22b9924d9ae6%40asus.

[Guy Rouillier]

Are you referring to MyBatis Migrations or Sql Workbench/J?

--

Guy Rouillier

To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/CAMWFgdhsCuA7fmdkGx%2B04JCLsJQo%3DGvSkoNaMWEO4eWs59pyvg%40mail.gmail.com.

[Yair Ogen]

Sql Workbench/J

To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/ema429aad9-e881-4f14-acfb-5807f5cdcbac%40asus.

[Guy Rouillier]

Check the manual on the site: http://www.sql-workbench.eu/manual/workbench-manual.html

It's pretty extensive.  The two primary ways the author intended this to be used is either interactively, or scripted via batch scripts.  I've used both frequently.  Don't really know what you might want to accomplish beyond scripting by including invocations from compiled Java code.  But take a look at scripting, it might do what you have in mind.  Just read on the linked page: "If you want to start the application from within another program (e.g. an Ant script or your own program)...", so the author thought of that, but only by invoking the main class he provides; he doesn't appear to have provided a documented class library that you can access directly.

Hope it helps.

--

Guy Rouillier

To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/CAMWFgdiCcA-1HNtG0HyC_KB1oE2M%2BNa1KZt7rx-FM7W8A55ZxQ%40mail.gmail.com.