# Heterogeneous database copy

**URL:** <https://forum.cloverdx.com/t/heterogeneous-database-copy/826>\
**Category:** CloverDX Platform\
**Created:** [February 20, 2011, 12:00am UTC](https://forum.cloverdx.com/t/heterogeneous-database-copy/826 "2011-02-20T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bryandowen](https://avatars.discourse-cdn.com/v4/letter/b/a5b964/32.png) [@bryandowen](https://forum.cloverdx.com/u/bryandowen)\
**Post date:** [February 20, 2011, 12:00am UTC](https://forum.cloverdx.com/t/heterogeneous-database-copy/826/1 "2011-02-20T00:00:00Z")

</div>

I’m trying to find a tool that will easily copy data from one database platform (MySQL) to another (Oracle). I don’t need to generate the DDL for the target database; I’ve already got that. All I want to do is to enumerate the tables in the source database, and mass-copy the data from each table into the identically-named table in the target database.

So far CloverETL is the only tool that I can get to work reliably (kudos!!). I’ve managed to migrate one table across so far. This was a very manual effort, creating the reader, the writer, the edge, and the metadata. My database has 118 tables, and I don’t look forward to repeating this process 117 more times. 🙂

Also, a handful of the tables have large BLOBs in them. When I tried to create metadata for one of these, I provided a query that just selected all fields from the table. CloverETL timed out attempting to retrieve metadata. I re-did the query with “limit 1” so it would only retrieve 1 record, and it still timed out.

So question # 1: Is there an easy way to automatically create a graph that will map source database tables directly to target database tables? This would rock my socks off.

Question # 2: If not, are there at least some shortcuts that will help me to quickly model all of the “readers”, “writers”, and metadata for the edges?

Thanks in advance!

-Bryan Owen

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [February 21, 2011, 9:51am UTC](https://forum.cloverdx.com/t/heterogeneous-database-copy/826/2 "2011-02-21T09:51:23Z")

</div>

Hello Bryan,  
you don’t need to create 118 similar graphs. You need just one with [dynamic metadata](http://www.cloveretl.com/documentation/UserGuide/topic/com.cloveretl.gui.docs/docs/dynamic-metadata.html). Create a graph like _ExtExamples/graph/graphDBUnloadUniversal.grf_ ([download examples](http://sourceforge.net/projects/cloveretl/files/cloveretl.engine/rel-3-0-1/cloverETL.examples.rel-3-0-1.zip/download)) and use RunGraph component to execute it for different tables.