Dbeaver: Implements database data comparator

Created on 6 Apr 2016  路  3Comments  路  Source: dbeaver/dbeaver

Use Story

As an user I want to compare table and database data.
Today the system provides a database schema comparator, but is extremely useful for database managers and software testers compare data.


Example

Database 1 - Table 1

| First Field | Second Field |
| --- | --- |
| 1 | 2 |
| 3 | 4 |

Database 2 - Table 1

| First Field | Second Field |
| --- | --- |
| 1 | 2 |
| 5 | 4 |

Diff between Database 1 and Database 2

| First Field | Second Field |
| --- | --- |
| 5 | 4 |

The feature can be used like the schema comparator.

feature


Use cases

  • Compare deployment and production database
  • Check algorithm's results in database
  • Help software CRUD tests
  • Help software regression tests
  • Generate data mutation history (log)
  • ETC

Sorry about my english (I am from Brazil ><).
Thanks a lot.

ee feature request help wanted

Most helpful comment

Good tables data comparer is implemented in the JetBrains DataGrip:
image

All 3 comments

That feature would be awesome.

As a software tester, in legacy system I can't mock or test software routines without database, and that's useful for check the result data.

I searched for a good software to do this, but I can't find nothing good and price free, and free software, impossible! :smile:

I think it will be a great feature!

My suggestion for implementation is export data to a file format like JSON and call the Eclipse file comparator. Today I use something similar, exporting the data to JSON files and using WinMerge to see the diff.
capturar2

+1 for this feature!

Good tables data comparer is implemented in the JetBrains DataGrip:
image

Was this page helpful?
0 / 5 - 0 ratings