README.md

In JW3148/dbcompare: Package compares data across sql server instances

dbcompare

The goal of dbcompare is to compare tables accross sql server instances. It provides tools to identify table dependencies for a given stored procedure; evaluate data discrepancies between source server and target server; It also provide a solution to manage reference data or lookup data across servers

Installation

You can install dbcompare from github with:

# install.packages("devtools")
devtools::install_github("JW3148/dbcompare")

Example

This is a basic example which shows you how to compare tables used by a stored procedure on two servers:

## basic example code
udf_CompareSourceTarget(source_server, target_server, db, proc)

JW3148/dbcompare documentation built on May 18, 2019, 8:07 p.m.