Dump DDL with selective data
Answered
Hi!
I wonder if it's possible to dump DDL (which I know how to do from PHPStorm) while also dumping data for some of the tables? I have a bunch of tables, that are kind of like "definitions", and I would prefer to have data from them in the same DDL files as, well, DDL themselves. But I do not see a way to do this (semi-)automatically in PHPStorm.
Any advice how to do this?
Thank you.
Please sign in to leave a comment.
It's not possible to store data in DDL data sources.
It is better to use "export data" option to store data: https://www.jetbrains.com/help/datagrip/export-data-in-ide.html
Is there a way to automate it somehow on IDE side?
What do you mean? Call export action after "Create DDL" action automatically?
Macro could be useful here: https://stackoverflow.com/a/32949699/8203759
Yeah, that's what I meant. I guess a macro could work for me. Thank for the info.