SQL Data Comparison

Answered

Hi, I'm new with DataGrip

Introduction: I have used Visual Studio + SSMS for a long time for most of my projects, but now I have some projects using MySQL and I am starting to use DataGrip for those projects.

The problem: I want to make a comparison of data like in Visual Studio / SSMS and I can't find something similar. Make a comparison of data and select the records you want to update to the target database.

A small example, the images are blurred: https://www.c-sharpcorner.com/UploadFile/31514f/sql-data-comparison-in-visual-studio/

Something like this: https://www.devart.com/dbforge/mysql/datacompare/ 

Does that exist in DataGrip?
if it doesn't exist do you intend to implement it?

1 comment
Comment actions Permalink

Hello,

Please take a look at this article https://www.jetbrains.com/help/datagrip/operations-with-tables.html#compare-table-data

Then, if you need to export, right-click on any row -> Data Extractor -> SQL Inserts (or SQL updates), select rows you need (multiple selection with CTRL) and hit ctrl+c. You will get SQL code in clipboard that you can execute against target database.

0

Please sign in to leave a comment.