Ability to dump/transfer routines?

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?

1 comment

Hello Tom,

There is no yet such functionality to dump a database, please vote and follow this request: https://youtrack.jetbrains.com/issue/DBE-1383

>Currently, if I select the routines and select "Copy DDL", it gives me 16 statements similar to the following (with no code):

We are working on it: https://youtrack.jetbrains.com/issue/DBE-367

0

Please sign in to leave a comment.