Date: 2024-09-30
Time: 14:00–14:50
Room: The Hub
Level: Beginner
When your system is active, data changes very quickly. You have made a backup, and the next hour, it won't match with the database anymore. You migrated the data from your old database to a new one, but while you are finalizing all processes, data stops being synchronized. Of course, you can compare the data in tables and find the differences. It's not difficult, isn't it? People don't usually consider comparison as a complicated operation. In real life, we do this all the time. That's why we take the data comparison task lightly. But it turns out that it's not as easy as we expect.
Let's review the main difficulties together: - What are the criteria to compare the data? - How to compare data between different databases? - What if you have billions of rows? - How to store the differences? - What is the best way to show the comparison result?
We have already gone through all these questions when developing the Data Comparison feature in DBeaver. Now, we are ready to share some tips and tricks with you.