Proposal: Find/ replace across multiple procedures/ functions

[expired user #8611]'s profile image [expired user #8611] posted 8 years ago in Feature discussion Permalink

Hello Ansgar, IMHO it would be very helpful to have an option to search (and replace?) text across all procedures/ functions of current database (especially if you write a bunch of MySQL procedures/ functions to do in database processing and you have to rename tables or something like that). I know this could be dangerous... Therefore, this should be an extra option in the find and replace dialogue which should be switched off by default. Best regards, Lutz

ansgar's profile image ansgar posted 8 years ago Permalink

Agree, a very dangerous feature :)

Wouldn't it be the easiest way to export your procedures and functions into an .sql file, then use a text editor to change what you want, then reimport that file again into an empty database?

[expired user #8611]'s profile image [expired user #8611] posted 8 years ago Permalink

Exporting and importing works - but it's quite a bit laborious :-/ "Bazaar trading": How about implementing only the find functionality? ;-) L.

ansgar's profile image ansgar posted 8 years ago Permalink

The "Find text on server" dialog has support for procedures and functions since recently. Only in MySQL mode yet.

Please login to leave a reply, or register at first.