PGLoader

Brand Details

Type: Product

Description: PGLoader is an open-source command-line tool used to load data into a PostgreSQL database from various sources, including other databases like MySQL, MSSQL, and Oracle, as well as from files. Its key advantage is its transactional behavior; it handles errors gracefully, continuing to load good data even if it encounters bad data, unlike the default PostgreSQL behavior which would stop the entire load process upon encountering an error. It also performs data reformatting, such as converting MySQL's representation of null dates to PostgreSQL's NULL value. The project's development happens on GitHub.

Website: https://pgloader.readthedocs.io/