siphonophora / sqldatacompare Goto Github PK

View Code? Open in Web Editor NEW

1.0 1.0 0.0 84.42 MB

A free web tool that generates SQL scripts for comparing tables or queries in SQL Server

Home Page: https://sqldatacompare.mjconrad.com/

License: MIT License

HTML 19.64% C# 78.89% CSS 1.01% JavaScript 0.46%

data-comparison sql sql-server sqlserver tsql validation

sqldatacompare's People

Contributors

Stargazers

Watchers

sqldatacompare's Issues

Get PWA working on github.io

Not a big deal, do this later.

dotnet/aspnetcore#19796

Better diff output?

Something like this might be an easier way to review.

Select Assert.Id 
     , '' [ ] 
     , Assert.Title [Assert Title]       , case when d_t.Id is null then '' else '!' end [ ]                                              , Test.Title [Test Title]
     , Assert.Author [Assert Author]     , case when d_a.Id is null then '' else '!' end [ ]                                             , Test.Author [Test Author]

From #Test Test                
Join #Assert Assert on Assert.Id = Test.Id 
left join #Discrepant__Title d_t on Assert.Id = d_t.Id 
left join #Discrepant__Author d_a on Assert.Id = d_a.Id

App could validate the template

Before actually providing the template to the user, the app could run it through validation. The validator would need to be refactored, and probably mockable, so we could verify the behavior from the templator.

Recommend Projects