Possible to generate a "sync" script to sync the data between two different tables?
已回答
We are evaluating DataGrip for purchase. We'd like to generate a sync script of sql inserts and sql updates to make the data of one database table (in our integration environment) to match the data of our development environment. So, rows that are in dev but not in int would have a sql insert, and sql updates statements for where the record exists in both, but one column is different.
Is there a way to do this in DataGrip? Or, what's the closest I can get?
I've been exploring it a bit but there don't seem to be too many options in the CompareData tool
请先登录再写评论。
Hi Kmacke,
I'm afraid it's not possible at the moment, but we have a feature request DBE-1204 to implement it. You can upvote it or follow for updates.