• 0

Database comparison software


Question

Hi!

Do you guys know any software/web app that allows you to generate reports stating differences between two tables?

I found comparezilla, but all it does is checks rows from top to bottom and see if they are the same ... eg:

Table 1

1. A

2. B

3. C

Table 2

1. A

2. B

5. E

all it would detect is that the third row is different ... not that rows 3 & 4 are missing from table 2.

Any ideas?

Newton

Link to comment
https://www.neowin.net/forum/topic/799824-database-comparison-software/
Share on other sites

8 answers to this question

Recommended Posts

  • 0

Rows are missing? The rows are not missing and I think you need to look at how you perceive database tables.

They are only row 1,2,3 in the way you have sorted them. They are not always given in that way. This is why an ID field is useful.

Anyhow, how large are your tables?

  • 0

Are we using MS SQL?

200 is very very small. OK, there's a few ways to accomplish this, but I don't have an SQL instance to hand...

How about you create a left join on the IDs, then use WHERE statements to see what doesn't match?

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • That adverting your referring to can basically be turned off with a few Windows settings. The only advertising I've seen in the last couple of years on Windows 11 is Outlook ads because I don't have a Microsoft 365 subscription. That said, it took me only a couple days to get used to ignoring those ads. I would prefer they weren't there but it's not a big deal.
    • Petty nerd sums up many peoples dislike for things. i.e. Windows 11
    • I've been using Windows 11 since the day it was released. No complaints whatsoever from me but then again, I always like trying new things. It's been ROCK SOLID running my Dell XPS 8940 desktop.
    • So many things to unpack here I don't even know where to begin...
    • Cjam 1.9.9.0 by Razvan Serea Cjam is a lightweight and fast MP3 editor for Windows that lets you cut, join, and edit MP3 files without re-encoding. This means your audio quality remains untouched, and edits happen instantly. Cjam is ideal for quick, lossless edits—whether you're trimming music, combining tracks, or preparing audio for learning tools or podcasts. It features batch processing, scripting support, cue and playlist file handling, and a simple interface. Cjam is perfect for anyone who needs efficient MP3 editing without the complexity of full audio suites. Cjam requires a PC running Windows 10 or later and Microsoft .NET 6.0 or later. Key features for Cjam: No Re-encoding: Edit MP3 files without losing quality. Cut and Join MP3: Easily cut, trim, and combine MP3 tracks. Batch Processing: Edit multiple files at once for faster workflows. Scriptable Interface: Automate tasks with a custom command language. Cue and Playlist Support: Handle CUE and playlist files for seamless audio management. Fast and Lightweight: Quick processing with minimal system resources. Lossless Audio Editing: Ensure your edits don't affect audio quality. Simple User Interface: Clean, intuitive design for easy navigation. File Format Support: Works with MP3, Cjam-specific file formats (CJAMC, CJAMJ, CJAM). Cjam 1.9.9.0 fixes: Fixed a bug related to playback display on the main screen Download: Cjam 1.9.9.0 | 1.3 MB (Freeware) Links: Cjam Home Page | Cjam Manual | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
  • Recent Achievements

    • Explorer
      Legend20 went up a rank
      Explorer
    • One Month Later
      jezzzy earned a badge
      One Month Later
    • First Post
      CSpera earned a badge
      First Post
    • One Month Later
      MIR JOHNNY BLAZE earned a badge
      One Month Later
    • Apprentice
      Wireless wookie went up a rank
      Apprentice
  • Popular Contributors

    1. 1
      +primortal
      635
    2. 2
      ATLien_0
      281
    3. 3
      +FloatingFatMan
      182
    4. 4
      Michael Scrip
      151
    5. 5
      Steven P.
      117
  • Tell a friend

    Love Neowin? Tell a friend!