ThreeEyedRaven91's ter-data-migration

A cool tools for migrate data from a database (maybe staging or development environment) to other database (production or staging)

You will never miss anything again.

How to use

Installation

npm install -g ter-data-migration

# or

yarn global add ter-data-migration

Config

Create .tdm_config folder

mkdir .tdm_config
cd .tdm_config

Create profile.json file

{
    "profiles": {
        "development": {
            "database": "your_database",
            "user": "your_user",
            "password": "your_password",
            "dialect": "mysql or something else",
            "host": "your_mysql_host"
        },
        "staging": {
            "database": "your_database",
            "user": "your_user",
            "password": "your_password",
            "dialect": "mysql or something else",
            "host": "your_mysql_host"
        }
    },
    "default": "development"
}

Run

# backup

ter-data-migration backup
ter-data-migration backup --source=development

# restore

ter-data-migration restore
ter-data-migration restore --target=staging

# migrate

ter-data-migration migrate --source=development --target=staging

# help

ter-data-migration --help

Options

See result

Everything in your db is exported with ${table_name}.json

Roadmap