This database software enables you to easily and quickly transfer data between various database formats in 3 steps without writing any scripts. It can directly connect to Oracle, MySQL, MariaDB, SQL Server, PostgreSQL, IBM DB2, Informix, Teradata, Cache, MS Access, MS Excel, Visual Foxpro, SQLite, FireBird/InterBase, Paradox, Lotus, dBase, CSV/Text and other formats, and transfer data(includes index, primary key, foreign key) between these formats (Access to Oracle, Oracle to SQL Server, SQL Server to MySQL, MySQL to PostgreSQL). The software offers a simple step-by-step wizard, that allows you to connect to the source database, select the tables, fields, and then convert and copy them to the destination.
Lots of datasources. It works pretty good for my Oracle-to-Postgres.
Cons
Oracle to Postgres generally good but BLOB to bytea doesn't work....causes tool to hang. Not sure what other gotchas I will hit when using binary or esoteric data types.
Interface is "small" give me a maximized window with a menu.
No basic SQL translation although that would be a pretty good tool.
Summary
Looks decent for a data ETL tool. Lots of datsources and trial run with Oracle/SQL Server/Postgres not bad. if these guys keep working on this, could be great. Not many other tools that do postgres and all the other datasources. 3 things to make it a killer app. 1. Clean up the binary data types and make sure other data types work well (they seem too), 2. Add SQL translation (like for Views and maybe Table Triggers) and its a killer app. 3. Make the interface bigger...felt like I was working in a tunnel :)<br /><br /><span class='notifyMsg'> Updated </span>on Oct 27, 2011<p/>UPDATE: Reported my bug with Oracle-2-Postgres BLOB-2-Bytea hang... they got back with me immediately....gave them data and circumstances. They discovered the bug (Null BLOBs) and created a point release patch version for me....this all in less than 24 hours. So good stuff! Still they need to add window sizability, a menu, ability to save migration "Profile/Settings" for later use and it will be a fuller product...but lots of great potential here and great service!
good
larbi_user
Pros
learning
Cons
Summary
Pretty!
gy_bbs
Pros
I use it convert mysql database to access and back, it done pretty!