knitr::opts_chunk$set( collapse = TRUE, comment = "#>", fig.path = "README-" )
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
You can install dbcompare from github with:
# install.packages("devtools") devtools::install_github("JW3148/dbcompare")
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)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.