This is a tool that helps database migration easy.
ESF Database Migration Toolkit Pro lets you transfer data between database formats. The process is a simple 3 step one. There is no need to write any scripts to do the migration. This toolkit makes things simple. Potentially, it could significantly reduce the effort, cost, and risk of migrating to/from a whole set of databases. These include Oracle, MySQL, SQL Server, PostgreSQL, IBM DB2, IBM Informix, InterSystems Cach窠Teradata, Visual Foxpro, SQLite, FireBird, InterBase, Microsoft Access, Microsoft Excel, Paradox, Lotus, dBase, CSV/Text, etc. Actually the database could be any with an ODBC interface. The interface is simple, and the newest recruit in the IT department should be able to take care of such transfers. The three steps of the process are selecting a data source, selecting the target and selecting the objects that must migrate.
The migration process can take care of all table structure, data, schemas in Oracle, SQL Server 2000 or higher, PostgreSQL, etc. Large Text/Binary Objects (LOB), primary key/foreign key, indexes, auto-increment (serial) and default value, etc. The software interface makes it simple for anyone to operate the tool. When migration must take place from one character set to another, the character set translation happens automatically. Field name, datatypes, nullable, precision, numscale, etc. can be transformed during migration. This tool offers DBMS Native API and bulk-insert technology. These features can easily speed up entire migration process. Really large database with multi-million records could be migrated without problems. This is a good product.