• 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

    • Prices have been unchanged for a looooong time, so really, it's time for a new price bracket, no matter how annoying it is. AAA titles just cost too much to develop these days. Personally, though, I tend to play mostly indie titles that are much lower priced and usually are far better games anyway.
    • Personally I don't usually play most games enough to justify paying £75 / $100 for a single game. I recently got a Switch 2 which came bundled with Mario Kart World, due to some discount codes I worked out I paid approx. £30 for Mario Kart World getting it bundled with the console. If I had paid £75 for Mario Kart World I'll be honest I would have been very disappointed with it. The big open world is essentially empty and lacking any real content, the changes to go GP mode mean you only really do one lap in most races... compared to Mario Kart 8 which has pretty much always been available for around £40 you have to ask why the game is almost double the cost? Look at all the content available in a Forza Horizon game compared to Mario Kart. For £30 I feel the game is ok, its not bad, however its not amazing either.
    • It was just a copy pasta from his other replies...
    • I think that the last game I bought on day-one was something like Ghost of Tsushima. I've come to realise that I don't have enough time (or sometimes inclination) to game as much as I used to, and I've got plenty of games to keep me occupied if I do decide to play. So I don't see the need to buy a game when it first releases - I wait until it goes on sale. If I'm really excited about a game and the price is under £50 then I would consider it, but anything over that price point gets ignored until the price comes down.
    • For the foreseeable that is your choice. I'm interested tom try one, my wife was very pleased because one she is anti-social and driver chat annoys her and two more seriously there is a long history of drivers abusing women, it's rare, but it happens and more than it should. Sometimes she needs to get a late taxi and she says it may make her feel safer.
  • Recent Achievements

    • Apprentice
      Wireless wookie went up a rank
      Apprentice
    • Week One Done
      bukro earned a badge
      Week One Done
    • One Year In
      Wulle earned a badge
      One Year In
    • One Month Later
      Wulle earned a badge
      One Month Later
    • One Month Later
      Simmo3D earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      603
    2. 2
      ATLien_0
      281
    3. 3
      +FloatingFatMan
      179
    4. 4
      Michael Scrip
      151
    5. 5
      Steven P.
      111
  • Tell a friend

    Love Neowin? Tell a friend!