Db-sync NPM | npm.io

db-sync

db-sync is a nodejs based tool for syncing databases between different environments. It basically consists of a dump() and a fill() method for dumping databases in one environment and deploying them into another.

Note: right now, db-sync only supports MySQL databases

Example usecase

Let's assume you are building a website powered by a CMS like Processwire. You may want to replicate the changes you make in the backend of your dev-environment inside your staging environment when deploying your code.

To automate this, you could use the dump() method on your dev, which will create a .sql file and the fill() method on your staging server, to push this dump to your staging database. Include db-sync in your build script and you're good to go :-)

Installation

via NPM:

$ npm install db-sync

Usage

var sync = require('db-sync'),
    dbConfig = {
        host: 'localhost',
        user: 'username',
        password: 'pwd',
        database: 'mydb'
    },
    tableBlacklist = [
        'settings'
    ];

sync.dump(dbConfig, tableBlacklist, './dump.sql');
...
sync.fill(dbConfig, './dump.sql');