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
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
-
Hello Bryan,
you don't need to create 118 similar graphs. You need just one with dynamic metadata. Create a graph like ExtExamples/graph/graphDBUnloadUniversal.grf (download examples) and use RunGraph component to execute it for different tables.
Please sign in to leave a comment.
Comments 1