dbcrossbar

Copy data between different databases easily

cargomacoslinuxwindows

Try with needOr install directly

About

Program for copying data between databases (pre-release)

dbcrossbar

export data from postgres to csv file$ dbcrossbar cp 'postgres://user:pass@localhost/db#table' 'file://output.csv'

import csv file into mysql database$ dbcrossbar cp 'file://data.csv' 'mysql://user:pass@localhost/db#table'

migrate data from postgresql to bigquery$ dbcrossbar cp 'postgres://user:pass@localhost/db#table' 'bigquery://project/dataset/table'

copy table from mysql to redshift cluster$ dbcrossbar cp 'mysql://user:pass@host/db#table' 'redshift://user:pass@cluster/db#table'

convert database table to json lines format$ dbcrossbar cp 'postgres://user:pass@localhost/db#table' 'file://output.jsonl'