Info
| Version: | 1.2.3 |
| Author(s): | Mike Beaton |
| Last Update: | Wednesday, April 29, 2020 |
| .NET Fiddle: | Create the first Fiddle |
| Project Url: | https://github.com/MightyOrm/SqlDataComparison |
| NuGet Url: | https://www.nuget.org/packages/MightyOrm.SqlDataComparison |
Install
Install-Package MightyOrm.SqlDataComparison
dotnet add package MightyOrm.SqlDataComparison
paket add MightyOrm.SqlDataComparison
MightyOrm.SqlDataComparison Download (Unzip the "nupkg" after downloading)
Dependencies
Tags
Pure SQL data comparison and reconciliation utility for SQL Server
Example usage:
* EXEC sp_CompareData 'MyTable', 'RemoteDb..TheirTable'
* EXEC sp_ExportAll 'MyTable', 'RemoteDb..TheirTable'
* EXEC sp_ExportDeleted 'MyTable', 'RemoteDb..TheirTable'
* EXEC sp_ImportChanged 'MyTable', 'RemoteDb..TheirTable', @ids = '43-44'
Supports:
* Column name remapping
* Columns filter
* Automatic primary key based or manual join columns spec
* And more...