db-compare

Compares two databases

Installation

coming soon

Usage

const config1 = {
    user: '',
    password: '',
    database: '',
    server: '',
    port: 1433,
    pool: {
        max: 10,
        min: 0,
        idleTimeoutMillis: 30000
    },
    options: {
        encrypt: false, // for azure
        trustServerCertificate: true // change to true for local dev / self-signed certs
    }
}

const config2 = {
    user: '',
    password: '',
    database: '',
    server: '',
     port: 1433,
    pool: {
        max: 10,
        min: 0,
        idleTimeoutMillis: 30000
    },
    options: {
        encrypt: false, // for azure
        trustServerCertificate: true // change to true for local dev / self-signed certs
    }
}


const mssql = new Mssql(config1, config2);
mssql.compareTables().then((data) => {
});

Test

Tested on SQL server 2019 15.0.2000.5

Collaborate

Please feel free to report feedback or bugs or ask for new features.