MsSQL Database Comparison

• .NET 6
• Blazor Server
• MudBlazor
• Dapper

Goals

The goal of this repository is to compare 2 same mssql database instance.

Installation

Open up your Command Prompt / Powershell and run the following command to install this repository.

git clone https://github.com/cihangll/MsSQLDatabaseComparison.git

Open appsettings.json file and change ConnectionStrings section. For example;

"ConnectionStrings": {
	"SourceConnectionString": "Server=.;Database=SourceAdventureWorksDW2019;Trusted_Connection=True;",
	"TargetConnectionString": "Server=.;Database=TargetAdventureWorksDW2019;Trusted_Connection=True;"
}

Execute the following command to run app.

cd .\MsSQLDatabaseComparison\
dotnet run

You can open the application at https://localhost:5001.

Application Features

• Table comparison
• View comparison
• Stored procedure comparison
• Function comparison
• Table column comparison
  • Columns
  • Data Types
  • IsNullable
  • Numeric
  • Default Column

Screenshots