Dump DDL with selective data

已回答

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.

0

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

 

0

Is there a way to automate it somehow on IDE side?

0

What do you mean? Call export action after "Create DDL" action automatically? 

Macro could be useful here: https://stackoverflow.com/a/32949699/8203759

0

Yeah, that's what I meant. I guess a macro could work for me. Thank for the info.

0

请先登录再写评论。