pgloader loads data into PostgreSQL and allows you to implement Continuous Migration from your current database to PostgreSQL. Read the White Paper to learn how to limit risks and control your budget, and start your PostgreSQL migration today!
pgloader has two modes of operation. It can either load data from files, such as CSV or Fixed-File Format; or migrate a whole database to PostgreSQL.
pgloader supports several RDBMS solutions as a migration source, and fetches information from the catalog tables over a connection to then create an equivalent schema in PostgreSQL. This means that you can migrate to PostgreSQL in a single command-line!
You can also migrate from database files in the DBF and IXF formats, where pgloader can inspect the target table format for you automatically in the file headers.
The White Paper titled “Migrating to PostgreSQL, Tools and Methodology” explains the idea of Continuous Migration. The paper also covers migration projects budget decisions and risks mitigation. It’s free and contains all you need to get started, including a PostgreSQL Architecture primer!