Skip to content

Getting Started

Jump to bottom
David Elish edited this page Dec 20, 2018 · 5 revisions
  1. The first thing you'll want to do is clone this repository.
  2. Now open the SqlResutlsCompare solution (SqlResultsCompare.sln) within a version of Visual Studio that supports SQL Server Database Projects (versions 2012 and higher).
  3. If Nuget packages (log4net and CommandLine) are missing, open the Nuget Package Manager Console (Tools -> Nuget Package Manager -> Package Manager Console) and execute the following: Update-Package -reinstall
  4. Build the project with the Release configuration.
  5. Navigate to the Release dir (\sql-results-compare\SqlResultsCompare\bin\Release)
  6. Review the SqlResultsCompare.exe.config file and make any necessary changes. Pay special attention to DBConnectionString, CompareExePath, and DefaultBCPServerName.
  7. Run the application from a command prompt with the -i option to deploy the SqlResultsCompare database that contains the objects necessary to execute remote queries and create the comparison output files (e.g. \sql-results-compare\SqlResultsCompare\bin\Release\SqlResultsCompare.exe -i).

**There have been some reports of the database installer failing with the message "Could not deploy package." If you encounter this error, an alternative way to deploy the database is to publish it directly from Visual Studio.

Clone this wiki locally