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

| Option | Short | Meaning | Example | |---------|-------|-----------------------------------------------------------------|----------------------------------------------------------| | source | -s | Define source environment (not working with restore) | ter-data-migration backup --source=development | | target | -t | Define target environment (not working with backup) | ter-data-migration restore --target=development | | include | -i | Only backup / restore with following tables | ter-data-migration backup --include=Users,Projects | | exclude | -e | Exclude tables backup / restore. Not working if include appear | ter-data-migration backup --exclude=Logs,PasswordReset |

See result

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

Roadmap

| Version | Function | Status | |---------|----------------------------------------------------------------|-------------| | 0.1.x | Read from profile (with default config) and run export to json | Done | | 0.2.x | Read from profile (with default config) and restore from json | Done | | 0.3.x | Add params profile, allow include or exclude tables | Done | | 0.4.x | Add params from, to and migration from profile to profile | Done | | 0.5.x | Add scenario file | To do | | 0.6.x | Provide API to programmatically migration, backup, restore | To do | | 0.7.x | Provide init command allow create profile.json | To do |