I have joined a new project, and have been giving DataGrip a try. Anyway, I have the "remote dev" mysql database set up as a data source, and I have my "local dev" mysql database set up as a data source. I had initially set up my local dev using another product, but I forgot to do a dump of all the stored procedures/functions/routines and transfer them to my local environment. So, I'd like to know if it is possible to do this via DataGrip. Currently, if I select the routines and select "Copy DDL", it gives me 16 statements similar to the following (with no code):
CREATE PROCEDURE delete_missing_vehicle_ids();
I can copy the stored routines over by opening the "remote dev" environment, manually editing each routine in the routine editor, copying and pasting the code to a console file open for the target environment, but I'm curious if there is any easier way to do this?